Linking one to many

[Keeperen]

Hello folks,

Newbie question:
I have 2 tabels. One with info on an invoice and one that is a "sub" table to the other where the price on the invoice is devided into cost manhours, cost material, Admin cost and so on.

The way the users are intended to use this DB is that they select the project, a specific invoice and in the invoice form they should be able to click a buttom to go to tab in data for tabel two. Then click save or update, so that the first form will show the summed up cost for the cosutmer.

So one invoice to many orderlines.....

How do I make a button that can when pushed in a specific invoice take the invoice_ID and automatically enter that in a cell in another form where you can put multible posts as cost manhours, cost material ect. so that the user will not have to remember and type in the invoice_ID for every post ?

In advance thanks.

Regards Keeperen.

 

[plog]

Newbie question:

Nope, not a single question in there.

 

[Steve C]

tblInvoice should have a One-to-many relationship with a tblTwo Field called tblInvoiceID

All the devided (sic) cost manhours (sic) materials and so on would appear on a Subform to tblInvoice – no need for a button – it’s all there on the screen in one Form (and Subform).

What did I miss?

Oh and one more thing – I am very new on here, don't rely on any thing I say!