Relational DB problem
I'm New to FM but have created many DB apps in the past. The question that I have is can I create in the Relational rules some where so that when I change the value of the Primary key of the parent table, have it cascade and change the linking field of the related records of the child table. Yes I understand that I could create a hidden serial field as the link. But I'm just asking the question as my previous developing tools relationships where always maintained with the rules that I specify
I'm just guessing that FM does this but I don't see where other than creating my own script to do so?
Amy thoughts would be appreciated.