I would greatly appreciate your help with the following...

If two tables (tblTrades and tblPortfolio) are linked in a many to many relationship via another table (tblTradesPortfolio) how can data be added using Forms? I am currently trying (unsuccessfully)to do this through Forms/SubForms that are bound to tblTrades and tblPortfolio. I am not sure how or whether to use tblTradesPortfolio?

Any thoughts...?

Make a form using your junction table tblTradesPortfolio.

The junction table should have look ups to the one side tables (tblTrades and tblPortfolio).

That's it.




mmcdonal

Duh!!

Thxs..