Add to two tables at once?

[David Nelson]

I have attached a file to help see my problem. We take trips and there are passengers. So I have a People table to hold them all. When adding a Passenger, if they are not in the People table we need to add them. Most times, the passengers are already in the People table.

I want to make users check the Persons list by opening the pop-up of People and hopefully select the passenger. If the passenger is selected, the First and Last name fills in because FirstName and LastName are from the people table. But if the person isn't there, they need to type into the first and last name fields to create the person in the People table and also insert their PersonID into the Passengers table.

I tried putting People fields in the Passenger portal and I have allow creation on both tables. But if I don't select from the list, I still can't type into the field to add a person. Most all my portals use allow created. I could handle this differently (script to go to Person table and back?) but I wanted to keep it the same 'feel and look' as other portals which allow creating right in the portal. How would you all handle this situation please?

AddPeople.zip

[comment]

How about this way?

AddPeople+.zip

Note:

This is a rough sketch - requires more error trapping.

[David Nelson]

Hi Comment,

You make it look so easy and so fast too. This will do it. There are more fields than I showed so I'll need to pause the User on the People layout so they can enter all the information (instead of custom dialog) but I had never seen custom dialog used like this so I am glad you did it this way.

For the life of me, I cannot see where you might error trap this script. You provide an exit for the User in case they change their mind. What other errors might I need to look for, if you don't mind my asking?

Thank you so much for taking the time to provide this demo!

[comment]

Well, for one thing, I can leave the names empty and press OK.

[David Nelson]

BONK! Of course!