I have a fairly sizeable database in development, a couple of hundred records by 20-30 fields.
For one application however, I need to reference/display one particular entry, i.e. the field entry of one specific record. I want to refer to this entry/text in another part of the database, and I'd like to use a reference so that if the particulars in that specific field entry are changed, my reference to it will also change.
I don't want that record to change with respect to whichever record is being currently viewed, I want that reference to always be the contents of that one specific field/record irrespective of which record is being viewed.
What's the best way of doing this?
Thanks from a newbie.