Many to many relationship help

A

Amy

Thanks very much Chris. I created 3 tables and related
them as you advised. Now here is another ? :

How do I enter data for the 1st (clients) and 2nd
(products) tables where the 3rd table (orders) will just
automatically updates itself with the entered information
from the first two?

And If I create form to enter data. how do I do that? I
want to have a form to show client info. first (client
table), then what he ordered (product table) with order
details (from order table)

Many thanks,

Amy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top