Saving a Primary Key to two different tables on one form

[RitaMoloney]

Saving a Primary Key to two different tables on the one form?

Hi,

On my form, I select a Job Name from a combo box (got from the Jobs table). I then fill out it's details (which are stored in a table called JobDetails.) I then select a boat name from another Combo box which is stored in BJDetails table . I also want the primary key from Jobs table to be stored in BJDetails table.

When I select Job Name I want it's primary key to be stored as a foreign key in BJDetails table and JobDetails table on the one form, is this possible?

This works ok if the primary key has only to be sorted in one table but is it possible to have it stored in two tables on the one form. I have attached a picture to show the layout of my tables.

Please help, as this is driving me mad.

Thanks,
Rita

 

[Mile-O]

Next time you decide to post please ensure you have the correct forum. Next time, take the time to read the Please read before posting thread.

 

[bradcccs]

Without looking too deeply at your structure:

Sounds like a task for a main form (Frm_Job) and two sub forms.

Subfrm_JobDetails & Subfrm_BJDetails

This way the two subforms can have seperate record sources (relevant tables) and you can relate back to one primary job form.