I have a list for Person in which there is a lookup column for StateID of States list. In States list there is a lookup column for CountryID of Countries. I want to add CountryID to Person list by using existing StateID lookup column, but when I edit StateID column from List settings of Persons list I didn't see choice for selecting CountryID lookup column to add in Persons list. Please help, please let know if this is the correct way to do this or if it is not possible.
States list must be have CountryID, then you can add that to Persons list. you can add CountryID as calculated id to States list and then you can see that when you want to create StateID lookup column.