Hi, I am setting up a connection between two tables, that have a 1:1 (one to one) relationship and trying to setup a connection between them when adding, and editing.
So far, I have a custom column with a link but now I must attempt including a second GET parameter in the querystring, not only the table name.
Is there a way to programmatically fire an advanced search on a specific field?
Alternatively, when adding or editing a record in the first table, I would be interested to automatically jump to the Add form in the second table, if the 1:1 relationship doesn't have a matching record in the second table.
Any way to do this without me spending a couple days building the code? I was happy to discover the pass-GET params thread on this forum. That made life so much easier!!