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?

There are methods of how tables are created and linked that will allow you to populate/ delete the tables in a cascade fashion. Here is a link that can provide some insight.
http://office.microsoft.com/en-us/as...875301033.aspx

I have a table setup in this manner on home server and when I add different data the key record only needs to be entered once. When I delete on that key record both tables go away.

I hope this will give you some ideas, assuming I understood the question.

Chuck

---
Chuck

Newlan's Truism:
    An "acceptable" level of unemployment means that the government
economist to whom it is acceptable still has a job.