Hi all. I have two tables that I'm working with. One is called tblconsumer and only has 3 fields. Consumer Number, First Name, and Last Name. The second table house a bunch of other data and is called pfl_master. What I'm trying to do is set it up if Consumer Number, First Name and last name are entered in pfl_master, they will create in tblconsumer. I have been able to do this by adding an event on the add page of pfl_master in Before Record Added. However, if I go back and try to create a second entry, I get an error that the consumer already exists. How can I make it update or ignore trying to create a new record if it already exists?
Thanks in advance.