Changing information in a created record that is connected by a relationship.

[tim413]

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

[Doink]

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

[mr_vodka]

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.

[tim413]

mr_vodka

Thanks Mr. Vodka for responding to my question.

Have a great day!!!!!

Tim

[tim413]

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, 2007 by Guest