Button to Open Report from Other Table.
I have been looking thru the postings, but cant seem to get anything to work. I have two tables. In Table 1 I would like to create a button that opens a report for table 2 in a popup window. Can so...
Forum Discussion
Actually, I reread your question and I answered it too quickly thinking the other tablecwas in a different app.
A better answer is this
Formula url field
URLRoot() & "db/" & [_DBID_MY TABLE NAME] & "?a=q&qid=99"
Lookup the table name from the Advanced properties of the table with the report and 99 needs to be replaced by the report ID#.
A better answer is this
Formula url field
URLRoot() & "db/" & [_DBID_MY TABLE NAME] & "?a=q&qid=99"
Lookup the table name from the Advanced properties of the table with the report and 99 needs to be replaced by the report ID#.