many to many and subform problem

[tekaccess]

Hi To all
I am working on this from last two week but no sucess, is any body help me out?

tblSupplier
supplierid(pk)
name
address
---
---
tblinvoice

invoiceid (pk)
purchasedate
supplierid

tblproduct

productid (pk)
name
---
----
tblinv-prod
inv-id (fk)
prod_id (fk)

What i want to do is that after selectinf the supplier id from supplier through combo, I want to store all record in product table(subform) under one invoice and so on, I just want to add invoice number only once.
Any detailed answer will be appreciated. I have already spend alot tome on this.
Thanks

 

[Pampers]

Maybe you should have a look at the Northwind sample database. You can find it under Access Help, Sample Databases, Northwind Sample Database. Take a good look at the Order-form.

Pampers
Keeping it simple can be complicated