Updating related record.

[fireemt1]

Please tell me if this is possible. Ok quick run down:

Horse.fp5

Name (text)

A Portal (portal of info) Displays (Horse Tasks.fp5::Name, Date, Task, and Notes)

Horse Tasks.fp5

Name (text)

Task (text)

Date (date)

Notes (text)

Now, lets say that someone changes the name in Horse.fp5 (which is the relationship between the files). Now all the info disappears from the portal. I know the reason why is because the records from Horse Tasks.fp5 is still the old name and the file Horse.fp5 has a different name. I need to know if there is a way and how to execute changing the name of the records in Horse Task.fp5 when someone changes the field "Name" in Horse.fp5.

Any replies would be greatly appreciated.

[Limulus]

Yep, there is. When you use an unique ID for horse, and for a horses task, you could make a many-to-many db using a join table(or file). The join-table would hold horse-ID, and task-ID. So, when you change the name of the horse, the horse-ID will stay the same, and that is used to create the relationship with task (through the many-to-many relationship created in the join-file).

[Ugo DI LUCA]

Quick answer.

Forget about Names and use IDs.

The Name would come through a related calculation ID::ID, then could change and be updated...

[-Queue-]

You either need a way to force the Horse Tasks file to update, or take the better route and don't base the relationship on something that can change. That is, make a Horse ID, along with the Name, and match the ID to itself in the other file.

[Ugo DI LUCA]

So then, you solved your own problem here, Limulus

[fireemt1]

Ahhhh ! So simple its stupid.... guess that's why im posting and not replying ! lol... thanks guys !