View Single Post
  #4  
Old July 16th, 2009, 09:43 PM posted to microsoft.public.access.forms
-Karl
external usenet poster
 
Posts: 15
Default 1 Form with 2 inputs for 2 tables

Awesome. Now I have another question. I want to be able to use Input
boxes where the user is able to Input data. Same theory as before
with the tables. But now after they fill in both fields and submit
the data, how would I be able to link the 2 tables (State and county)?

I am guessing that I would need to INSERT the state data, then run a
SELECT query to pull the ID out. If so, how would I assign the ID to
a variable or whatever so that I can inject the ID into the County
table? I am guessing that once I am able to assign the ID to a
variable, I would run a SQL command to iINSERT into the county table
values [variable], country name ??

I hope I made sense.




On Jul 16, 12:52*pm, KARL DEWEY
wrote:
Search on Cascading Combos.

--
Build a little, test a little.