dennismoorejr

Create a record in Table X based on record info from Table Y.

Discussion created by dennismoorejr on Jan 14, 2018
Latest reply on Jan 14, 2018 by dennismoorejr

I am trying to create a script which allows the user to create to create the following;

 

Table "Participant"

ParticipantIDpk

First Name

Last Name

cFullNameLastFirst (calculation that combines names listed as last first)

 

Table "Transactions"

ParticipantIDfk

additional fields.

 

I am trying to have a new record created in Transactions table based on the current record selected in the participant table.

 

I have the following as a base to get started but am not having any luck populated the Participant

 

Screen Shot 2018-01-14 at 11.09.42 AM.png

 

The to have the StampTrans::_ParticpantIDFk populate from the Participant table record associated or selected.

 

If Participant Table Record was

 

ParticipantIDfk: 0063

First Name: John

Last Name: Kennedy

 

The purpose of the script is to create a new record on the Stamp Transaction table based on the the participant record table.

 

Happy New Year and thanks as always for the insight.

Outcomes