Link/button to open specific form
I have a report that lists customers. When I choose a customer it brings up a form that has a ton of useful summary info about the customer brought in from many parts of the application (this i...
Forum Discussion
no problem
here is the formula
urlroot() & "db/" & [_DBID_CUSTOMERS] & "?a=dr&dfid=XX&rid=" & [related customer]
You get the [DBID_CUSTOMERS] which is the name of your Customers table from the Advanced Settings for the table.
The dfid ("da form ID") is from the URL you see when you preview the form.
Then you need to either feed it the record id ("&rid=" & [the field containing the record id of the customer]) or else you can also feed it a key field instead ("&key=" & [my key field])
here is the formula
urlroot() & "db/" & [_DBID_CUSTOMERS] & "?a=dr&dfid=XX&rid=" & [related customer]
You get the [DBID_CUSTOMERS] which is the name of your Customers table from the Advanced Settings for the table.
The dfid ("da form ID") is from the URL you see when you preview the form.
Then you need to either feed it the record id ("&rid=" & [the field containing the record id of the customer]) or else you can also feed it a key field instead ("&key=" & [my key field])
Works great! Thanks Mark! And thanks for the quick reply!