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])
Thanks Matt. Location number is not a key field in both of these tables. I tried this as is by changing the FID but I am getting syntax error 'expected a valid expression after the "&".
In this formula where is it matching the location number with the table I am calling from?
In this formula where is it matching the location number with the table I am calling from?