Reading multiple values from another table.

[cowiefr]

I have a table with general information in it such as Subject,
Reference Rumber, Comments. I would like to have another table with
Company Reference and Responsibility. So when I create a new record
including Subject and Reference Number, I could look up values from
the second table to fill in multiple instances of Company Reference
and Responsibility. A better example would be a form to order pizza.
The main form would contain name, address, Size and type of pizza.
Then from the same form, you would look up toppings from a seperate
table to add multiple toppings to each instance of a pizza. Clear as
mud? If anyone can help here I would appreciate it.

Fain

 

[Guest]

two choices:
A) Use unbound form
B) use a subform (for toppings, size...) on your main form

rocco