I have been struggling with this for days. I guess that "Do the same thing and expect different results" thing comes into play here.
So here goes. Hope someone can help.
So, I create a blank DB and add a few fields.
I change the filed name to whatever, like States, Location and Climate for instance, save it as Destinations and close.
Create three more tables named States, Location and Climate.
In each of these, enter in a vertical column, 3 or 4 states, NW, SW, NE and SE for the Locations and HOT and COLD for the last one.
Save and close all.
Then open Destinations in Design view, select the field States, Use the Lookup Wizard to set up communications with Enable Integrity checked with the table States. Save and close.
Repeat for the other two Fields, Location and Climate.
Then, with Destinations selected but not opened, I create a form, save and close. I have even closed Access down and come back in just to make sure.
I open the Destinations table and enter enough data for a couple records.
Then I open the form. The cell which should have a state in it, has a number, like 1,2 or 3, depending on which record you are looking at.
So, obviously, I'm not quite doing it correctly. I've watched video on the subject until I need a drink! So, if anyone out there can help with doing it correctly, well, it would be greatly appreciated.
Thanks to the community in advance!