help me please.

[Guest]

I have one table " Invoice register" where i enter all inv details .(one
record for each invoice)
also in this table , there are fields for draft details.
after issue draft i have to enter number , date etc. for each record in the
"invoice register.
but my problem is , usually many invoices are paid with one draft . so in
these cases i have to open each record and enter the same draft number etc.

this is time consuming and it may create mistakes .

so instead , i want to create another table "drafts"
in this table i will keep the draft no , date payee.

i have created one form "drafts form" and want to creat a subform to show
all the invoices covered by draft( these invoices are of course an existing
records in the table"invoices register) how can i do this. what should i do
in order to link selected records from "invoice register " to a draft (a
record in the draft table)

i.e. one record in the "drafts" will match many records in the "invoice
register" which are already there in the table before entering drafts details
in the "drafts"

need your help.

 

[Guest]

Before you work on the form/subform, you'll need to have a related key field.
The InvoicesRegister table should have a field that is a foreign key to the
primary key in the DraftDetails table.

Drop the invoiceDetails form onto the other form as a subform. Then, with
the subform selected, you need to fill the Link Master Fields and Link Child
Fields properties to link the related fields from both tables (you can click
the elipsis (...) next to one of the fields to bring up a helper for
selecting fields).

Barry