I have a form that will add data to say mainTable. In the form, I want to get some data like last name, first name and client_number from a linked master table (using a combo box) and have that data added into mainTable . I would also like to enter data (last name, first name and client_number) that are not in the master table, but I don’t want the new data to be added to the master table. I just want the new data to be added to mainTable . So mainTable will have data from the master table and also have data that was added using the form. How do I go about doing this?