Table problem

[ajnhlr]

Would someone please take a look at the attached db and give me some guidance on why the field "State" is not functioning properly.

Thanks

GRH_Contacts_v3.fp7.zip

[Genx]

Could you please explain what the state field is supposed to do? Is it meant to retrieve a value based on the city or is the post code meant to fill based on the city / state?

[Genx]

Also just as a suggestion, rather than replacing the post code / zip code with the words "wrong format", just make the content red and create a tooltip explaining why its the wrong format. Wiping the users data doesn't always make them very happy.

[LaRetta]

The State field on your Contacts Management layout is based upon other_database2. Change it to be based upon your Contacts Management table. :wink2:

[ajnhlr]

Genx,

The state field is supposed to give the user a list of U.S. States with full name and abbreviation. When the user selects a state, the abbreviation only is inserted into the field.

Thanks for the suggestion on Wrong Format. I hadn't thought about your point. It would be easier to just make the correction than starting over.

LaRetta,

The state field needs to display a drop down based on the Table "other_database" to produce what I stated above.

Thanks, Genx and LaRetta

[LaRetta]

"When the user selects a state, the abbreviation only is inserted into the field. The state field needs to display a drop down based on the Table "other_database" "

I understand. But the FIELD on your Contacts Management layout is based upon the other field. The VL should be ... the FIELD shouldn't be. :wink2:

[ajnhlr]

I'm sorry. I'm not following you.

[LaRetta]

In the tab control for addresses. The FIELD state is your other_database2 field. If you want to plant the state into your Contacts Management table (home state, work state etc) then the field must be based upon Contacts Management - like all your other fields on that layout.

A value list is just a method for selecting values from elsewhere ... and can be attached to any field. But the field itself (where you want the data inserted) should be - well, the field where you want the data inserted.

Double-click that state field and change it to Contacts Management Spouse Home Address state (or whatever) and try it then.

[ajnhlr]

LaRetta, thanks.

I'm old and I've slept since I had it working. Your suggestion works, but I'd swear it's not the way I had it. No matter; just as long as it works.

George