store many records against one Invoice number

[tekaccess]

Hi to all
I want to store many records against one invoice number. I want a user enter only once a invoice number then add many record against that invoice number and that invoice should be repeate automatically. Like
Invoice date productID SupplierID
100 x x x
100 x x x
200 y y y
so on
Any help
Thanks

 

[PHV]

Have a look here:

http://r937.com/relational.html

The sample Northwind database installed with access has similar scenario.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tekaccess]

Thaks for ur advise.
Aactually I am picking supplier information from combo box It displays the record of that supplier but after that i have to put the invoice number and against that invoice number i have to put many record.
I am getting many records but the invoice number is still only once.
tblProduct
==========
ProductID(PK)

ProductName
and many more

Invoice
========
productID(FK)
InvoiceNumber
InvoiceDate
SupplierID


I can not see invioce number under product ID
Any Suggestion
Thanks Again

 

[PHV]

Seems you should have an Invoice table and an InvoiceDetail (1:n) table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tekaccess]

If u don't mind can i send u my table structures
Then give me any remedy accordingly

 

[PHV]

Have you the link I gave you ?

http://r937.com/relational.html

Have you tried to understand how the Northwind database was built ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886