Hello everyone...

...working on a bunch of things at the same time...

I have a table PERSONS and a table ORGANIZATIONS. The records of both tables are connected via another table called MEMBERSHIPS.

Example: _pk_ID_MEM0004 has the foreign keys _fk_ID_PER0006 und _fk_ID_ORG0003.

The foreign key _fk_ID_PER... from the Memberships table has the same entry as the primary key _pk_ID_PER... from the Persons table.

When you are on a layout based on Persons you can start a script that takes you to a layout based on Memberships where the script creates a new record. The user has two fieds, _fk_ID_PER and _fk_ID_ORG, and with a drop down list in each field he can create the desired combinations.

So, right now there are two blank fields on the layout, with the mentioned value lists attached. However, it would be great if the user (when switching from the Persons layout to the Memberships layout) finds already the Persons ID in _fk_ID_PER from the person record he just came from.

Has anybody a clue what I could put in in such a script to get the desired ID in the _fk_ID_PER field?

(If this here is too difficult to understand I can easily write a little database. Let me know)

Thanks so much,

Mike :)

Hey there,

after a very long night of playing with variables I found a nice way :

Set Variable [ $_fk_ID_PER; Value:Persons:_pk_ID_PER ]

Go to Layout [ “Combination_PER_ORG” (Memberships) ]

New Record/Request

Set Field [ Memberships::_fk_ID_PER; $_fk_ID_PER ]

Hope it’ll help in case the question comes up again.

Regards!

Mike