many to many classical data entry problem

[ikselle]

I'm a relative new in Access but i've looked around on many sites to find a solution to my problem which seems to be common for entering data with many-to-many relationships.
I like to give users te possibility to find out who's registered with which car (numberplate) and on the other hand which numberplate is registered on which person.
I've made a frmDataEntry (based on a name) but it doesn't show the numberplate(s) of the owner. I know that there is a solution with a combobox but i can not figure out how to get this right.
Can anybody please show me how to do it. It should not be so difficult but i simply cannot get around this problem.
I would really appreciate it.

 

[boblarson]

I'm a relative new in Access but i've looked around on many sites to find a solution to my problem which seems to be common for entering data with many-to-many relationships.
I like to give users te possibility to find out who's registered with which car (numberplate) and on the other hand which numberplate is registered on which person.
I've made a frmDataEntry (based on a name) but it doesn't show the numberplate(s) of the owner. I know that there is a solution with a combobox but i can not figure out how to get this right.
Can anybody please show me how to do it. It should not be so difficult but i simply cannot get around this problem.
I would really appreciate it.

You were simply missing a Row Source for your Combo box and then setting the Column Count to 2 and widths to 0";1" (or use equivalent cm if applicable).

See revised version.

 

[ikselle]

Thanks a lot Bob !! This kept me busy form more than two days.