entiring data from af orm to a table

[moonlight via AccessMonster.com]

Hi all,

I want to use a form to enter the data from it to a table 2 which is easy,
but my problem is how to pick items (in the form) from another table 1 and
save it in table 2 :


Table 1 Table 2
items 1-Job with many items
2-Job with many items
3- ............
4-................

Form
Entering the job (and saved in 2) with some items (from 1) used in this job.



I try to put a diagram put I could not, I hope the a bove will be clear for
you..

 

[Steve Schapel]

Moonlight,

Basically you need a 3rd table here, where you would save the items
associated with each job.

So Table 2 is for the information directly related to the Jobs. And then,
there is a one-to-many relationship between the Jobs, and the JobItems.

In the Items table, you should have a Primary Key field to uniquely identify
each Item. And in the Jobs table, you should have a Primary Key field to
uniquely identify each Job.

Then, in the third table, you would have a "foreign key" field, to relate to
the key fields in each of the other 2 tables.

When it comes to the point of managing this data on forms, then you would
have a subform based on Table 3, which would be placed as a subform on the
Jobs form. So each Item related to any given job, would be shown as a
separate record on the subform.

Not a complete answer here, but hope this will point you in the right
direction. I suggest if you can get a good Access bookm or some other way
you can read up about table design, normalisation, and relationships.