Excuses my ignorance please. The question I have, has been answered in various ways, but I have yet to grasp the concept.
I have 2 Tables, each Table has a single field with 2 entries.
Table 1= “Customers”
Filed name= “FirstName” and has 2 entries “Test1” “Test2”
Table 2= “Categories”
Filed name= “CategoryName” and it has 2 entries “autoTest1” “autoTest2”
The form has a List Box for “FirstName” and a simple text box for “CategoryName”
When I select a name from the drop list I want the “CategoryName” to auto fill the appropriate data corresponding to the list box selection.
For example: If I select “Test2” from list box I want the “CategoryName” box to auto-fill with the appropriate response “autoTest2”