[AccessD] Cross referencing records - ideas

Drew Wutka DWUTKA at marlow.com
Wed Jun 18 00:33:34 CDT 2003


Are you asking for a method of providing an identifier, or a whole solution?


I think you are saying that they want to refer to other memo fields, from
within a memo field they are creating?

What I would do, would be to provide them with a 'refering' option, that let
them 'search' the current memo fields.  Take the ones they selected, and
either add them to the end of the memo, or keep the data in a separate
table.  (You could add it to the existing memo field, by putting the primary
keys for the table after a null character, then change your displaying forms
to display only data left of the null character).  Then, in the form that
users display the memo fields, just add a subform, or listbox that is titled
'related job cards', with portions of the text in them.

Drew

-----Original Message-----
From: Bruce Bruen [mailto:bbruen at bigpond.com]
Sent: Wednesday, June 18, 2003 12:06 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Cross referencing records - ideas


Hi List,


I'm looking for ideas.  I have an application that involves fairly
simplistic action history tracing, so simple it is done by a memo field.
That is, the yewsers completes a textbox for an action and when they
save/exit the contents of the textbox are appended with a timestamp to
the memo field.  Works completely fine for the need.

I have been asked whether it would be possible to do the same thing for
the "occasional" need to cross reference rows in the master table.  They
would like to include a note of the ilk "See also job card xxxxxx".  

Simple! Except... There is no readily available natural key for the job
card. Depending on the situation the natural key is nearly all the card!
I don't want to use or expose the surrogate key for all those good
reasons.  

My initial reaction is to include a realtionship table that would be
used to hold "Related Job Cards" and build a popup based "Link to Card"
form and a popup based "See related Cards" form to support this.
However, I don't think the usage warrants the expense.

Has anyone had a similar experience and found an inexpensive answer?

Tia
Bruce

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list