Change report link within parent table report

Mark,

I have gone through the other thread's post and think I understand it.
However, it isn't working as I thought it should.
My thought is that I am to blame for not doing it correctly ... as is typically the case.

So to give a bit more detail:

I have my parent table report where I have created a URL Formula to take me to the report of the child table.
That is working. It takes me directly to the customized report instead of the default report.

However, what is not currently working is that it is showing me all records from the child table. It should only show me records from the child table related to the parent table.

I have the URL coded with filters as per the thread/post you shared, but I don't think they are working correctly.

I am trying to filter for the Parent Record ID# of the child records, so that only the child records related to the parent record are showing.

The related parent record ID# fid in the child table is 22. Yet when I click the link, the URL comes up with some triple digit fid being filtered.

In order for filtering to work via URL formulas, do they have to be columns that one can normally filter, as in on the left hand side? The Parent record ID# is not a filterable field by default.

Here is the code I have so far:

URLRoot() & "db/" & [_DBID_Table_1] & "?a=q&qid=7&nv=1&v0=" & URLEncode([Job ID#])

Also strangely, my child table is called Notes, but the table Alias is Table_1.  All of my other tables have a matching table alias. I found that strange ......

------------------------------
Andrew
andrew.fry25@gmail.com
------------------------------