In my application each User fills out a form that creates a "report" the same way an Order is filled out in an Orders table.
The master table each User refers to when they create a Report is a table of Doctors records or a table of Pharmacists' records.
In the details list pages one of the first fields seen is the name of the Doctor or the Pharmacy--which is a lookup wizard interpretation of a field which actually contains the ID of the master record.
The Pharmacy field in the (details) Report list page for a User might contain pharmacy_id 245678 but the User sees "Bellagio Pharmacy" under the Column label "Pharmacy".
But we have situations where the Pharmacy field may contain the same name because there are several branches or because different owners gave their pharmacies the same names but perhaps they are one town apart.
I would like the User to be able to hover over the Pharmacy Name field and get a popup record Preview of the Pharmacy name with more complete information to determine WHICH "Bellagio Pharmacy".
How would we create the same Preview for Master table records looking from the details record instead of the usual PHPRunner details-from-master record preview?
Thanks for your help.