Can you embedd one of the current table's reports on a form that has the currently open form's record highlighted in the report?

Not easily.  I can think of an approach, but it would not be a casual undertaking.  You would need to control how a user accesses a record to view or edit it, and then have them click a spewcial buttn to View or edit the record. 

That would record the user's "Focus Record ID#" and then that Focus Record ID# would be able to be looked up back down into the table and then a formula would be able to highlight.

Ok.  These users can't edit.  It is not a hard requirement for my task.  More of a curiosity at this point.  I think I'll pass on it for now, but thanks for the reply as I may reference it again in the future if needed.

I am totally confused by your question. Do you have one table you are dealing with or are their two related tables involved? I am sure there is a ridiculously short solution to your problem using script so please elaborate or even attach an annotated sketch of what you want things to look like.

I believe the OP is saying that there is a single table of say Orders. Then on that table there is a form of a particular open order. On that form she wants to list all the open orders which she can do with the report link field and a filter on the report to just so show open orders, but she wants to highlight the order record she is sitting on which is appearing I�m on others in that embedded report of other open orders.

It is basically one tiny line of script. View or Edit a record:




Highlight Row In Embedded Report
https://haversineconsulting.quickbase.com/db/bm6ytxgqx

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=608