Solved: Adding a new row from a referenced table within a ... - Page 2

Mishta_P · 12-15-2024 02:50 PM

OK. I have been trying to avoid this post for a week.

I have a simple contacts database.
I have a simple tournaments database.
I have a linking table for when I want to register Contact to a Tournament (they will also register as Yes/No/Maybe, but that is not overly relevant).

I have a virtual column within my contacts table that looks up any upcoming tournaments that the contact is NOT registered for (here is where my headaches started).

**I have also tried a virtual column in the tournaments table to, which achieved a similar result but in reverse, with no luck**.

On the customer details screen I have the list of Unregistered Tournaments.

This acts as though it is in the Tournaments table so...

If I create a "Register" action on here I can add a row to the linking PlayerRegistrations table with the TournamentID (Tournament.Row ID) easily, however I have been unable to find a way to bring across the Contact ID (Contact.Row ID) as part of the same action, or series of linked actions.

I have tried every combination of linktoform, context, thisrow, parent, getrow etc etc. I have tried various ways to temporarily store the Contact ID data in the tournaments table.

I have searched everything I can, and even spent some time with ChatGPT and Gemini, who both get into a loop around _Parent or _Context etc which I had already failed on.

I have created similar functions in other apps with no issues, both coded and no code, but can't seem to work my way through this one.

Happy to provide any screenshots, although I am not sure they will be overly helpful as I am not getting errors, just not able to achieve the last part in something I think should be fairly straightforward.

Any guidance would be greatly appreciated.

TeeSee1

I can suggest one way though it is not exactly what you are looking for.

I would create an ENUMLIST of reference to Tournaments in the Contacts table and in the suggested values, list unregistered tournaments for the contact.

After the user selects tournaments that they want to register for, then use this technique (variations of it) to add to the registration table.

If your action runs on the tournaments table, there is no way that I am aware of to indicate where you are on the Contacts table unless you somehow 'tag' the row. (This would be another approach)

Anyway, either way, it would be a two step solution for the user and I cannot think of any one step ways to achieve this.... (I would also love to be surprised otherwise)

View solution in original post

Adding a new row from a referenced table within a details screen