Form with multiple list

[Donyk]

Hello Everybody,


I am new here and new access user with the following problems:

I have 3 tables: suppliers, customers, products.

I want to create a form (therefore a table, let's call it "quotation" ) which allows me to:

1) select the name of the customer and have few fields like address, tel, etc. to appear automatically.

2) select the name of few products and have few fields like price, description etc. to appear automatically.

I managed the point (1) as the customer in the form is only one. I did it by inserting in the form's design the "existing fields".

I am not able to do the (2) as I need to insert a list of product (not just one), and I am not able to create such a list which, for every product selected, fills up automatically its other associated fields.

Is this possible by using Access's tools (maybe modifying things in the design mode) without programming in VB?

I thank you very much in advance for your help.

Donyk

[Datagopherdan]

Yes, this is all possible. You need to decide how you want to display the information though. For example you could have it displayed by customers with all the products they've purchased or you could have it displayed by products with all the customers that bought that product etc.

[Donyk]

Customer with all products they purchase.

Thanks a lot.

D