Script would look something like this (pseudo) example:
Being on the Student record, click button 'New Registration' ...
New Registration script:
Set Variable [ $studentID ; Students::StudentID ]
Go To Layout [ Registration layout based upon Registrations table ]
Set Field [ Registrations::StudentID ; $studentID ]
Go To Field [ field you want User to begin typing in ]
thank you so much.
How to I ge:t Set Field [ Registrations::StudentID ; $studentID ]
I edit script
click on Set Field
select StudentID in Registration
and then? how to I select my variables $studentID?
Mahalo from Hawai‘i
Notice that the first line of the script writes the StudentID of the student record you are on, into a variable by using the Set Variable script step while on your Student record. Then when you go to Registrations, you set the Registrations StudentID with the variable.
You specify the variable right within the calculation - just type $studentID. Make sure that what you type matches the variable name you created in the Set Variable step. So it would be:
Set Field [ Registrations::StudentID ; $studentID ] ... just typing the red portion in the calculation dialog.
thanks firgued it works. GREAT. worked about 10 hours on this.
any idea how I can have more then one field show up.
like first name, last name, ID, address?
Take only the ID with you through your script. Once the relationship has been established (inserting StudentID into Registration record) then ALL of the student’s information is immediately available to use how you wish.
You can cross-place any Student’s fields (such as name) directly on your Registrations layout … just insert your Student field onto Registrations. Or you can set your Registrations field(s) to Auto-Enter Lookup or Auto-Enter Calculation to permanently insert into Registrations. You can read up on them in FM Help (search for Auto-Enter and Lookup).
When would you cross-place related fields and when would you insert the data? If you cross-place fields, Registration display of Student data will update if the Student record changes. This is usually fine for things such as Name, email, DOB. But you may want to insert the address at the time of the registration (using auto-enter or lookup) so next year, you have a record of the Student’s address at the time of last year's Registration even if they moved since then. These are business decisions which only you can make on each of these fields. :^)
IT FINALLY WORKED.
THANK YOU SO VERY MUCH.