Hi,

I have made three tables: Meetings, People, and a People-Meeting join-table. I need to create a button in the Meetings table that brings me to the People-Meeting table, create new record, and then autofill the last serial number from Meetings into the Meetings ID field of the newly created record in the People-Meeting table.

I've only managed to make a script as follows:

Go to Layout ["People Meetings"]

New Record/Request

Go to Field ["People Meetings::Meeting ID]

But I don't know how to do the autofill part. Can anyone help please?

Many thanks!

See this thread and the demo that I attached.

Thanks bcooney, that's way better than my original idea!