Change layout and pass primary key to other layouts
I have a a layout called jsa that is pulling from the jsa table. I have another layout call lift and is pulling from the lift table.
I have setup a primary key and FK between the 2 in the database. (jsa_id = jsa_id_sub)
My issue is that when I switch from one layout to the next, the layouts are not passing the PK to the FK.. So the data is not related..
I have looked for how to do this and come up empty.. I believe I will have to use a script I just don't know how to do it..??
Any help would be greatly appriciated..