I have the following tables: (See Attachment)
I am trying to add a new record to the tblClients using a form(frmClient). Most of the fields will be data entry, however some fields will be pulled from other tables using ComboBoxes. (cboBrokerName, cboEnrType, cboRenewalDate, cboEDIFF, cboEDI, cboAM)
I would also like to be able to use this form to cycle thru tblClients to edit the records.