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