Problem with table relationships - Foreign Key and Primary Key

[Alico]

Hi,

I'm a newbie with access, and I have a problem understanding table relationships.

My application is a single session where I want user to input some data in forms. The data are basically checklists for a single job, but I want to logically separate them in forms or tabs. All data should be related to the Job ID that he enters in the first form.

I tried to separate the tables based on the tabs with the primary key in the first table as "Job ID", but I don't want the user to enter the "Job ID" in every form, just once and it should update the foreign key in the other forms. But this doesn't happen.

Is what I'm asking possible? or am I doing something wrong?

Thanks for your time & help.

Regards,
Ali

[June7]

Are you using form/subform arrangement? Have you set the Master/Child Links properties of the subform container control? Review: http://office.microsoft.com/en-us/ac...010098674.aspx

[Alico]

My problem is, I want the user to enter the primary key "Job ID" only once, and the foreign key in all other tables should create a new record with this value automatically.

What I understand is that the master/child and subforms works only when you already have the data in the other tables.

[June7]

No, that is not the case. The Master/Child Links will cause the PK of the main form to be saved as foreign key in the subform record. That's a primary purpose behind the form/subform arrangement.

JobID is not an autonumber field?

[Alico]

No, that is not the case. The Master/Child Links will cause the PK of the main form to be saved as foreign key in the subform record. That's a primary purpose behind the form/subform arrangement.

JobID is not an autonumber field?

The JobID is a number entered by user not auto, so my problem is it doens't transfer aytomatically and the user have to input it again. I want to be able to copy this number from master to child.

Is there a way I can copy the PK to FK?

Thanks,
Ali

[June7]

Doesn't matter if the primary key is auto or user input. If the field is defined as primary key in table and form/subform arrangement properly set up, the value will automatically save into the subform record.