Saving one or more items to a table from Combo box

[RitaMoloney]

Hi,

I have two questions.

1st Question:
On my form (frmSurvey), I select a job name from a combo box (get from Jobs table) and then enter it's details in another table (JobDetails table). I then, select one or more employee names (Employees table) from a list box to be stored in EmpDetails table.

So far so good, the problem is when I select the employees from the list box and press the save button I get a Error Message.

If I save the record after I enter the job details and then select the employees from the listbox and save again, it works fine. But this involves having two save buttons. Is it possible to save the information by only having to press one save button?.

2nd Question:
I also want to select one or more parts used for each job (PartName from Stores table) and save there details in PartsUsed table. I have used a combo box to select a part name from the Stores table and save it details in PartsUsed table.
(The PartsUsed table is joined to JobDetails table through JobDetailsID.)

It will only allow me to save ONE Record with the same JobDetailsID number. I want to be able to save many Parts used with the same JobDetailsID. How do I get around this?

I hope this makes since, please can you help me. I have attached a picture of my table layout and a picture of my form.

Thanks in Advance,

Rita

 

[Mile-O]

Can you descibe your table structure?

 

[RitaMoloney]

Can you descibe your table structure?

Sorry, I had ment to attact my database example but it was too big so I have attached a picture of the layout of my tables and a picture of the form I am working on.

I hope you understand it.

Thanks again,

Rita