Apache OpenOffice Community Forum

Hi,

I have a generic inventory query as source for a report listing assets by room.
Since the table is populated by way of a listbox from a lookup table, the query inherits the pk and the report subsequently shows the integer as location rathen then the actual name.
How can one create some runtime procedure that will prompt for the location by way of a listbox which will pass on the location name to the report.
Any ideas will be welcome

Thanks

SELECT "Name" FROM "Table_A" JOIN "Table_B" ON "Table_A"."ID"="Table_B"."AID"

Table_A:
ID Name
01 John
02 Paul
03 Ringo
04 George

Table_B:
AID
03
02
04
01
04
03
02
04
01
01

Query Result:
Name
Ringo
Paul
George
John
George
RIngo
Paul
George
John
John

Thank you,
Gruss aus Chile