Table relationships for Combobox

[Lukael]

Hello everyone,

I have one problem that Is killing me, and I'm an Access beginner.

Problem description:

I have Main table with fields also for Maintainance_Man, Technic_Man and User.

Then I have second table with fields _Name,_Surname.

Those three fields in first table should have comboboxes with drop-down list of all names of people from second table, to select name and add value in field.

So basically I'm just pulling data from second table to fill It in first table, in order to create a record.


Question:

1. Is the proper relationship between table many-to-many or one-to-many ?

2. Or Can I just add combobox to form of Main table, link It to records (Name,Surname) in second table and with Change_Event add values to
fields Maintainance_Man, Technic_Man and User ??

P.S: Solution has to be done this way - If I delete fields in Maintainance_Man, Technic_Man and User, the Name and Surname fields in second table should be left intact.

I hope I make any sense

thanks for help !

 

[pbaldy]

On a form bound to the main table, you'd have 3 combo boxes bound to each of the 3 fields, each with a row source that got the selections from the second table. Where it gets tricky is in a query, you add the second table 3 times to the grid, and join each of the 3 fields to a different instance of it.