Copy ID from one portal/relationship -> create 2nd

June 30, 200421 yr

In the good old days of FM6, I would have used a script in the second file to facilitate this. However I'm now trying to figure it out in FM7.

Attached is a simple db with a few tables. Essentially there is a list of trades and services that can be selected. This is in a seperate file as apposed to an included table.

Upon selecting the category of trade and service, I wish to click on the trade, and have that copied (not just referenced) to the portal above in a new record.

Any suggestions?

OPENME.zip

June 30, 200421 yr

Author

LOL - my brain don't work too well after a night of drinking....

The solution:

Script in main file:

Set field TEMP --> Get ( PortalRowNumber )

Set field TEMP --> Trades::TradeID

After that, it's easy to create the second entry. The trick was revealed in that in order to get the TradeID there needed to be reference to the record, which is obtained by the process of getting the PortalRowNumber....