Foreign key field not updating relationship with ESS

[El_Pablo]

Hi,

 

My students are developing a project in Filemaker using the separation model. The FM data file connects to a MySQL database.

 

I noticed that when updating a foreign key value on the Presentation layer, the view of the value on the related table does not update. Like if the relationship didn't updated.

 

Eg :

• I have a "buildings" table and a "building_types" table.
• There is a field "buildings::fk_building_type_id" which is related to "building_types::id".
• I am using a layout attached to BLD__BUILDINGS in the presentation layer.
• In the layer, there are two fields "BLD__BUILDINGS::fk_building_type_id" and "bld_BUILDINGTYPES::name".
• When I change the "fk" the "name" does not update directly. I must commit the record.
• Doing so in the data file, the update is instantaneous.

What is the reason for this behaviour?

 

Thanks for helping