One Form to Multiple Tables
I have a table called Leads. The layout for leads (as pictured) is a form. I need to come up with the most efficient way to write data in the green outlined area to the table called Accounts, and the data in the blue outlined area to the table called Contacts. The magenta outlined areas will be written locally to the Leads table. The caveat here is that I need there to be a way where the user is prompted to remove assoicated records if they delete the lead.