Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Populating a field based on another field's value


chevy
 Share

Recommended Posts

Hey all,

 

Have patience, I am teaching myself filemaker.

 

Ok, at this point I have a Customers table and a Contacts table. They are related via CustomerID. There can be many contacts for one customer.

 

I have a field in the Contacts table called "Same Address". If the value of this field is yes, I want "address, city, province, postal code etc..." to be copied from the Customers table into this Contacts record.

 

Any help is appreciated.

 

Thanks!

 

p.s. have tried to make Contacts::Address a calculated field using: If(Contacts::Same Address="yes";Contacts::Address=Customers::Address ;"")

- but it doesn't seem to work - if it says yes, there address field fills with a 0...??

Link to comment
Share on other sites

Figured out folks:

Changed it to:

If(Contacts::Same Address="yes";Customers::Address ;"")

 

But Chevy does this also allow you to enter data into the fields to as when I have tried using calculated fields they lock me from entering data into them...

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use