Jump to content
Sign in to follow this  
Rodd

Pop-up to Drive Field Changes

Recommended Posts

Is it possible in FM 8.5 to use a pop-up field choice to change other fields data. Specifically, I would like to have a field defined as a pop-up that has "Billing", "Shipping" to drive which address is displayed.

Share this post


Link to post
Share on other sites

If you create a relationship from your customer table to the customer address table, keyed on customerID and perhaps a field calling address type. Each record in the customer address table should be assigned a type. Then you can use a value list on the customer-side AddressType and put the related fields on the layout. So when you change the type now, the related record data will change.

Share this post


Link to post
Share on other sites

mr_vodka,

Thanks for the quick follow-up. I created what you suggested, have two tables, customers, addresses, linked by customer_id, and I have a field in the addresses table called address_class. I used the Address_class field to hold "Home", "Billing", "Shipping". The pop-up works fine, but when I change the value, instead of changing the address, it just updates that record. For example, where I have a "Billing" and "Shipping", I end up with say "Shipping" on both records.

Is there some setup on that pop-up field I'm not doing?

Thanks

Share this post


Link to post
Share on other sites

It needs to be linked by customer_id and addresstype_choice <--> customer_id and Address_class.

Then you can put the related, city, state, zip, etc of child address record on the layout.

Share this post


Link to post
Share on other sites

Wouldn't that infer I keep the address_type in both tables? Being an Oracle guy, that kinda goes against my DB genes because that forces me to create two records in my master table (customers), one for each address_type. Or am I misinterpreting that?

Share this post


Link to post
Share on other sites

In spite of your user name and it's inference with all things blurry, it hasn't effected your technical vision.

Thanks much, I got it working.

Share this post


Link to post
Share on other sites

Is your Avatar telling us what you think of our Forum. :giggle:

Every time I see it, it reminds me of my son's response to my mother-in-law's changing his diaper. She choose to do this on her couch, that no one was allow hardly sit on, let alone eat, or drink while sitting on it. HIs fountain went right over her shoulder, and onto the couch. I still chuckle at the memory (so does my wife, and the rest of her family).

Anyway, back to FileMaker.

Lee

Edited by Guest

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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