Cross referencing between records

[tanc]

Hi does anyone know if there is a way to cross reference between records?

For example I have a memo box where the user would write that the item is simular to record [34] (34 being the PK of that record) what I'd like to do is click the 34 to send me to that record rather than search the database.

Thanks

 

[Ranman256]

you cannot query memo fields. Otherwise you can cross reference fields in a query.

 

[CJ_London]

only way you could do this is by have a table of references displayed alongside the memo (so not within the text).

memo fields do not support hyperlinks as such, but it may be possible to create some vba code which the user can use to indicate that this bit of text is a hyperlink, and another bit of code which if the user clicks on it can then identify that it is to be treated as a hyperlink and take the user to wherever