Jump to content

Table problem


This topic is 5662 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

"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:

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5662 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.