Update hyperlink display text

[d-mcc56]

Hey all,

So I have a table with 2 fields.
The first field has the addresses to multiple hyperlink paths to folders on my computer.
In this field the display text matches the hyperlink paths.
In the second field I have the desired display text for field 1.
I have tried using an update query to either:

1) Change the display texts of field 1 to match field 2 while preserving the hyperlink path
2) Add the hyperlink path from field 1 to field 2 without altering the display name.

I cannot get either one to work. Upon updating field 1, I lose the path, and upon updating field 2, I lose the name.
Can anyone help me out?

Thanks!

 

[Mihail]

You "feel" that you need 2 different information but now you wish to, somehow, concatenate this.
May I ask WHY ?
My advice is to keep the actual structure of the table.
If you haven't an ID field add it (autonumber)
Design a form based on this table and, if you like, make invisible anyone of the 2 fields.

 

[d-mcc56]

Well the hyperlink paths are very long and bothersome to look at, the display texts I wish to have are agreement numbers for construction. It is more efficient for our inspectors to see the agreement number in the table straight up rather than looking to the end of the path to see which agreement is which.

 

[Mihail]

Never never ever expose the tables to the users.
The users should be able to see only FORMS.
So, follow my previous advice: design a form based on the table.