It would help to see the relationship involved here so we can see exactly what "breaks" when you change a value in the other table. I could be that you have two fields for the same data--one in each table where you should only have one so that your changes appear automatically. It could also be that the relationship should be based on a different field and in other cases, you may want to implement a script that uses your update to find and update records in the related table--but this is usually avoidable if you set up your relationships and layouts correctly.
This is one section of the database, where services are put together, all realtionships are: one field "=" one field
That doesn't tell me anything that enables me to help you.
Something like this would help:
table::keyfield = anothertable::anotherkeyfield
where each table and field is named. Then use this information to explain how changing a value in one table is affecting the other.
Service Time::Service=Service Details::Service
Where changing Service Details::Service does not cause any changes in Service Time::Service field but if I click on any recod in Service Time::Service then click off it will get flagged by validation as not being a member of Service Details::Service.
What kind of field is service and under what circumstances are you making this change?
I could be wrong, but I think you should have this relationship:
Service Time::ServiceID = Service Details::ServiceID
Where ServiceID is an auto-entered serial number in which ever of these two tables functions as the "parent" of the other. Remove the service field from Service Time and replace it with a copy of the Service field defined in Service Details. When you edit this field, all changes will now appear automatically.
Your value list can be used to select the ServiceID field as the column 1 value and can display the service field as column 2.
As a general rule, fields used as a primary key to link one table to another should not be modifiable and should always have an auto-entered unique value (Which in FileMaker means an auto-entered serial number field).
That helps, and solves my problem. I needed serial numbers and to insert a copy of Service Details::Service Name, not a new field with a lookup of Service Details::Service Name. Thank you for your help.