I'm a mySQL dev working with a lawyer who is an amateur MS Access user.
Current Access has a
The relationships are understood in Access and bridging table functions correctly. The table is populated (I believe) by the following query:
SELECT TB_BoardMembers.ID, TB_BoardMembers.First, TB_BoardMembers.Last, TB_BoardMembers.Occupation, TB_BoardMembersLINK.Person, TB_BoardMembersLINK.Entity, TB_BoardMembersLINK.Role, TB_BoardMembersLINK.start, TB_BoardMembersLINK.end
FROM TB_BoardMembers LEFT JOIN TB_BoardMembersLINK ON TB_BoardMembers.ID = TB_BoardMembersLINK.Person
ORDER BY TB_BoardMembers.Last;
Lawyer needs to add an element for looking up unique Person in the form which creates the bridging table rows. Ideally this would be a with Last, First - job title for each Person. She is trying to get interns to populate the database.
I don't know Access at all or the Access terms for these elements. Can anyone explain how to do this in Access?
This resource explains how to create the list/combo box.
It does not mention that memo fields are not eligible as possible fields in the Lookup and that is worth noting if you are (like me) unfamiliar with Access.
A list box, combo box, or drop-down list box can be a bound or unbound control, and it can look up values in a fixed list or in a table or query. To create a bound list box, combo box, or drop-down list box that looks up values in a table or query, make sure the form or data access page is based on a record source that includes a foreign key field or Lookup field.