I have two tables... (simplified view below)
tbl_registration
id, name, paymentMethod
tbl_guest
id, registrationID, name
a person puts all their info in tbl_registration (selecting paymentMethod print, call, mail)
they add "guest" (linked as child table)
When done - they are on the Guest List page - I want to have buttons on that page that direct them to instructions for PRINT, CALL or MAIL based on what they put for payment in the master table.
I put this in the List Page for tbl_guest
LIST PAGE: After Record Processed
' Place event code here.
' Use "Add Action" button to add code snippets.
if rs("tbl_registration.Payment")=1 then
row ("payment1")=true
else
row ("payment1")=false
end if
obviously, it's not working...