Hi there.
I have created a new table to be used for a specific purpose (let's call this Table A). What I would like to do is link this table to our firm contacts table so that, if the information exists in the contacts database, it will populate Table A. The fields I want to use in the contacts table are name (first & last), company name and address.
However, if in Table A I need to enter a name that does not exist in the contacts database (which will be about half the time), then I would like to be able to add this name anyway and have it be added to the contacts table as a new record.
Is this possible? If so, how?
Thank you!
Lori