I have a related table. I want to modify the "add record" to only view the child record. Basically I want to recreate the "View Record" eyeball icon that is found in the report table. (I don't want my users to have to find this tiny little eyeball. I need a big glowing button for them to click on.)
I was able to write the formula that references the correct table, but I can't pull the correct Record ID because it is pulling the Record ID of the parent table. I need the Record ID of the child table. Is there a way to reference the Record ID from the related child table or just reference a Record ID from a different table?
URLRoot() & "db/" & [_DBID_TEST] & "?a=dr&rid=" & [Record ID#]
------------------------------
David Semitekol
------------------------------