Complicated database

J

Jeff

I am attempting to create a form that will update a table
in a specific way..

I'm attempting to create a form for a job.. the job will
be assigned an ID number. We may work on one or several
items.

How do I create a Form where I can enter one or many items
so that it will update to the table correctly (so that
they all fall under the same Job ID number?) The ID
number would need to repeat for as many items as are
entered on the form, and then move on to the next number
when a new form is started.

Please help!
Thanks
 
J

Jeff

What we are doing is we issue work orders that require
that either one or several skus will all be on. For
example.. work order #1 may have item #333, #444, & #555.
All are associated with work order #1.

I am attempting to create a Form that will transfer
several lines of data to one Table. I only know how to
create a Form that will transfer to one line on that
table, I need to be able to create one or several lines.
The work order # will need to remain constant for as many
skus as are on that work order and change the next time
someone creates one.

I hope this is clear.

Thank you all
 
L

Larry Daugherty

Hi Jeff,

It's fairly simple, not complicated at all. |:)

You need to organize your data in two tables: tblJob and tblJobItem.

tblJob would have information that relates to the job only, not the items.

tblJobItems would have its own primary key and a long foreign key that's the
primary key of tblJob. data about this instance of this item in this job
goes into this table.

In the relationships window draw a line to connect the Primary Key of tblJob
to the foreign key in tblJobItem. Enforce Referential Integrity and allow
cascading deletes.

The most intuitive way to represent the data is to base a form on tblJob and
insert a subform that's based on tblJobItem.

HTH
 
Top