Hi,
is it possible to have a column in a table control showing a list of
items from the target table having the column value as primary key?
I tried the following:
Mainform ("orders")
|- Subform ("order_items" shown in table control,
e.g. orders - ordered items)
Tables:
"orders"
ID
customer
...
"order_items"
ID
OrderId
ItemID
...
"items"
ID
short_name
price
...
In the Subform I wanted to make one column a other-table-lookup-type,
like using the column "ItemNo" for looking up the item short description
and price in the third table "items" and show that as the table controls
column value (the visible text). I didn't get there ... please help or
tell me it's impossible.
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
