Link/button to open specific form

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]:

URLRoot() & "db/" & [_DBID_Customers]& "?a=dr
&dfid=2
&rid=URLEncode([Location No]) 

Syntax if needing a query:

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)

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? 

What are your two DBIDs?  _DBID_Customers  & What?
What are the field IDs for the [Location No] on those two tables respectively?_

Thanks,  One is _DBID_CUSTOMERS and the other is _DBID_STORE_MIRROR.  Field IDs are 40 and 8 respectively. 

From your Customer table you'd need a formula-URL field with the equations:

URLRoot() & "db/" & [_DBID_STORE_MIRROR] & "?a=q&query={8.EX."&[Location No]&"}"

From your store mirror it would be:

URLRoot() & "db/" & [_DBID_CUSTOMERS] & "?a=q&query={40.EX."&[Location No]&"}"

Notice you are clicking the button from one table, but searching for the match in the other table

For now I used the statement for store mirror and this works great but it only shows the relevant record listed as a report.  Any chance I could open a form? 

Only if the field you are using for the query is the key field.

Yes that is the issue. It is a key field in the table but not quite in the other.