AnsweredAssumed Answered

Any suggestions on adding a new record to a subtable?

Question asked by user26705 on Sep 10, 2016
Latest reply on Sep 10, 2016 by cortical

I am working on a system that allows guests to be registered when they enter a data center.  The solution has two tables - one to register the guest and one for the visit details. This allows a single guest to have multiple visits.  There is a relationship between the tables that I defined.

 

The current layout uses a portal and my hope is that the user could hit the "new visit" button and enter a new visit for that user in the portal.  I have "allow new records..." checked in portal setup.  I realize that due to the layout of the portal I cannot see the blank record and portals don't seem to support a tab.

 

I have created a script that does the following:

 

 

Set Variable [$GuestID; Value: GuestRegistry::GuestID]

Go to Layout ["VisitDetails" (VisitDetails)]

New Record/Request

Set Field [VisitDetails:GuestID; $GuestID]

Go to Layout [original layout]

 

...that script runs - the actual layout opens...as opposed to just creating a new record in the portal.

 

At the end of the day I don't care if I use a portal...I simply just want one screen where I can add new visits to the sub-table - all ideas are welcome and appreciated.

Outcomes