Inserting data into 2 tables
I have 2 tables: Names, which contains an id, FirstName and LastName, and Address, which has a NameID, Address, City, State, and Zip fields. The NameID field needs to be the same as the id in the Names table.
When a user views my form for the first time, they need to enter all of their appropriate data then click an "Add" button. Can I add the data to both tables at the same time? If not, can I get the NameID without having to perform a query to get that id from the Names table?