Relationships?

[chrizzis]

I have a members table and a position table.
One member can have only one position, but one position can have many members.
How do I show this in the relationships? Is the table setup correct:

tbl_mbr
(PK) mbr_ID
...
position

tblRef_position
(PK) position

I tried to set the relationship:
tblRef_position.position 1 to many tbl_mbr.position

...but when I tried to make a combo box, I set the Control Source to position, and the Row Source to SELECT tblRef_position.position FROM tblRef_position;
and I got a weird #Name?
Do I need to restructure my tables? Create a junction table?

I do want to set up a query showing all members belonging to particular positions, so I am guessing I will need a table tracking this, but I thought junction tables were for many-to-many relationships on both ends.

 

[chrizzis]

I deleted the relationship and reconnected it enforcing referential integrity. I don't know what I did, but it works now.
Now I need to figure out how to make the combo box expand the reference table if the position is not in the list.