Hi everyone,

Thanks for having a forum on filemaker!!!!

My question is how do I create a relationship, so I can change information in a record that has already been created.

Sample10.fp7 in the Filemaker tutorial is my example. In this example, you will see how you cannot change the company name in a record once it is created. How do you create relationships so the company name can be changed if someone changes jobs?

I realize this is a newbie question, but I cannot find the answer from my searches.

Thanks!!!

Tim

Tim, ironic you posted this..I just asked the same question (more or less). If you see anyone reply to my post check it out since it may have the answer.

doink

I havent seen the files but if you have a key ID for each company (CompanyID) and then refer to this companyID key in your contacts table then it will do what you want.

IOW, you should have a serial number that is used as a primary key field for both your contacts table as well as company table. Also in your contacts table there should be a field where you store the ID of the company that the contact is associated with.

mr_vodka

Thanks Mr. Vodka for responding to my question.

Have a great day!!!!!

Tim

Here is an update.

Thanks for your help Mr. Volka!! I was not able to apply this to the data base I have been working on. For some reason it did not work, but I started a new data base using your tips and your advice worked.

Have a great day!!!

Tim

Edited April 4, 200718 yr by Guest