displaying new record in related table in original table form
Operating system version
Description of the issue
I am creating a table of school names/address with a related reservation request table for visits to the Museum. The names/address table is linked to the reservation table with a School_ID number. My script button does indeed create a new record in the reservation table but when I return to the original layout (school names/address table) I cannot get the newly created reservation record to display so that I can make changes to it. I don't want to use a portal but want this record to be editable from the school names/address layout. Do I need to create an identical layout to the school name/address layout but have it relate to the reservation table? Or is there another way to do this that I cannot fathom?