Is there a way to search for a record, (and ideally link it) in table B based on an email address field in table A, whilst entering the new record in table A?- I dont mind if it fails if it finds duplication or none, but it would save me much time to automate this?
Thanks in advance!