Updae Many - to - Many Form Help Please

[AndrewJDixon]

Good morning all. First post here so hello and thank you in advance.

I have a Access database with the following tables / fields:

Donngle
--------
Dongle_ID (PK)
WorkstationName

StaffMember
-----------
Staff_ID (PK)
Staff_Surname
Staff_Firstname

As these tables are many to many, I've created a linker table:

Dongle_Staff
------------
Dongle_ID
Staff_ID

What I would like to do is create a form that will allow users to add staff members from the StaffMember table (from a combobox) to a dongle.

I have used the form wizard to create a form focused on Dongle with StaffMember as a subform but my skill ends there.

I am learning Access as I go but have a good understanding of DB design.

Many thanks,

Andy

 

[dhookom]

The subform would have a record source based on the Dongle_Staff table. This subform would display a combo box bound to the Staff_ID field and would have a row source like:

SELECT Staff_ID, Staff_Surname & ", " & Staff_Firstname
FROM StaffMember
ORDER BY Staff_Surname & ", " & Staff_Firstname

Set the Link Master/Child properties Dongle_ID.


Duane
Hook'D on Access
MS Access MVP