RelationShip Error

[johnwiliams]

HI,

I have a table called STATE in which following fields are there-

1.STATE_CD (PRIMARY KEY)

2.STATE_NAME

There is another table called CITY in which following following fields are there-

1.STATAE_CD (FOREIGN KEY)

2.CITY_CD (PRIMARY KEY)

3.CITY_NAME

what i want is that after selecting particular city from the

drop down the state associated with this city should be displayed in the edit box.

plz tell me how can i do this i m really stuck in this small problem .

plz help me.

The relationship associated with this shown in the pic.

Thanks,

John.

[ron G]

Take a look at CityState.fp7. I think this does what you want to have done.

Basically, I use a popup that incorporates all the states in the STATES table.

If you are interested I have USZipCodes.fp7 table. It might save you some typing? 8-)

Attached below is the US Zip Code Table that shows: City, State, County and Zip.

Cheers...!

you. ron

CityState.fp7.zip

USZipCodes.fp7.zip

Edited September 8, 2009 by Guest
Add Zip Code Table

[johnwiliams]

Thnks.