Table or form

J

JennBard1

I belive I want to create a form i which i can put in invoices that refer to
a specific Job how do I do this and also be able to insert many invoices to
that same job without having to create a form in which i have to insert the
number of boxes before hand because there are a different amount of invoices
for different jobs. Is there a way to like the invoices to the specific job.
If so how?
 
J

John Vinson

I belive I want to create a form i which i can put in invoices that refer to
a specific Job how do I do this and also be able to insert many invoices to
that same job without having to create a form in which i have to insert the
number of boxes before hand because there are a different amount of invoices
for different jobs. Is there a way to like the invoices to the specific job.
If so how?
Click to expand...

You have a one (job) to many (invoices) relationship. Therefore you
need two tables in a one to many relationship - data is stored in
Tables, and not in Forms.

If you base a Form upon the Job table, and a Subform on the Invoices
table, you can enter any number (millions if need be <g>) of invoice
records related to a single job.

John W. Vinson[MVP]
 
Top