"By listing the province for each city in the recordset, you have a piece of data that can be used to create the relation ship."
Ah, okay I misunderstood you. Yes, I know it has to be in that recordset to establish the relationship. I thought you meant it had to be displayed in the second drop as well.
So a correct procedure would be to create a recordset with just provinces and states for the first drop and then a recodset with provinces and cities for the second drop? Because thats the way I am trying to get it to work, but can't for some reason.
Brad