Discussions

Can you display a table's report on a form that highlights the current form's record on 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.

Oh that is easy to do with script. Let me give you a head start with your native solutions and we can compare notes.

There is not a good native solution. It would take me 45 minutes working with my solution to get it working.

I tell you what - put in a User Voice suggestion for a native feature and I will give you a two year head start. To make it a fair challenge I will not use any script technique that does not already exist as of today. Deal?

no deal :)

Let me sweeten the pot. I will give you a ten yeas head start for your native solution and on my part I will come up with a dozen uniquely different ways to solve the same problem with script. Deal?

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

That is what I was looking for.  Thank you so much!