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
I am trying to use the same approach but in my case I have two unrelated tables with one field in each that matches. So tried the following but no luck.
URLRoot() & "db/" & [_DBID_Customers]& "?a=dr&dfid=2&rid"& [Location No]=" &[Location No])
URLRoot() & "db/" & [_DBID_Customers]& "?a=dr&dfid=2&rid"& [Location No]=" &[Location No])
You have to know the Key field to find that is on the other table (i.e Record ID), If [Location No] is not the key field you cannot go directly to the record, but rather you will have to do query to find that [location no]
Syntax if Key field is [Location No]:
(this is assuming your location fid in the new table is FID 11)
Syntax if Key field is [Location No]:
URLRoot() & "db/" & [_DBID_Customers]& "?a=drSyntax if needing a query:
&dfid=2
&rid=URLEncode([Location No])
URLRoot() & "db/" & [_DBID_Customers]& "?a=q&qid=1
&query={11.EX."&[Location No]&"}
(this is assuming your location fid in the new table is FID 11)