I have a many-to-many relationship set up with a join table: I have ConsultantT and VendorT which are linked in ConsultantXVendorT (with fields ID, ConsultantID, and VendorID). I used the relationship window to set up explicit one-to-many relationships between ConsultantT and ConsultantXVendorT as well as VendorT and ConsultantXVendorT. Now, I am building a form for a user to enter Consultant data, which is based on ConsultantT.  In order to make a combobox where the user can select the VendorName from an existing record in VendorT for a new consultant, how should I pull in the VendorID//store the data that is input?  I tried to use the wizard to build a combobox but since there is no VendorID field in my ConsultantT, I got a bit lost.

---

Reply from Alex Hedley:

If you've got it as a subform on ConsultantF you can just add as many Vendors as you need and have the ConsultantID take from Forms!ConsultantF!ConsultantID.