Populating a field based on another field's value

[chevy]

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 filss with a zero...??

Edited October 5, 2006 by Guest

[BobWeaver]

Change it to:

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

[chevy]

Tried that, now it just stays blank.

[chevy]

Realized it might be sensitive to caps, and it works...Thanks so much