Can two related tables both relate with the third Table?

[athanas-jifunze]

I have a table called tblCity(CityID, CityName, StateName) this table is related to a table called tblState(StateID, StateName) I have the third table called tblParticipant(ParticipantID, ParticipantName, ParticipantSex, ParticipantState, ParticipantCity) Is it possible the two related tables (tblCity & tblState) both relate to tblParticipant? I want to make the ParticipantState and ParticipantCity to look up values in from the two tables above.

[ssanfu]

Well, yes.
Are the fields "CityID" and "StateID" both autonumber PK fields?
Are the fields "ParticipantCity" and "ParticipantState" both Long Integer type fields?

[athanas-jifunze]

Yes, the fields "CityID" and "StateID" both are autonumber PK and the fields "ParticipantCity" and "ParticipantState" both are Long Integer type fields

[NTC]

tblCity contains both the City & State fields. If you the developer has populated this table completely - then you don't need tblState....but if that is all set up together already - that's fine.

Your Participant table can have the City field be a Look Up field type of the tblCity and include both City & State fields.

Then at the Form level - when the City field is automatically going to be a combobox/selector control - and you can make it display both City & State fields during the selection process - -(you can also set it to sort by State or City if that helps) - - however once selected only the City will display. It is the key field that will be bound to the control but the City field that will display in the control. In order to make the State display you put an unbound StateField =[CityFieldName].Column(2)

[athanas-jifunze]

Thank you very much for your explanations. However it can be very useful if I can share with you the database and ask the areas which I am not clear. If that is fine with you how do I share the database with you. Thank you in adavance