Adonaioc
10-15-2008, 07:18 AM
I have 2 tables
- one with part numbers and descriptions
- one with desriptions specs and hyperlinks to files
I have a make table query that combines the the 2 into one table that has
it all. I did this to save time on data entry, many part numbers have the same descriptions and specs minus a color variable that is not important in this application.
Instead of a part number field and a hyperlink field I want a field that is read as the part number but when clicked opens the hyperlink.
So part number "A1" has link "1" when it is clicked. Can this be done?
- one with part numbers and descriptions
- one with desriptions specs and hyperlinks to files
I have a make table query that combines the the 2 into one table that has
it all. I did this to save time on data entry, many part numbers have the same descriptions and specs minus a color variable that is not important in this application.
Instead of a part number field and a hyperlink field I want a field that is read as the part number but when clicked opens the hyperlink.
So part number "A1" has link "1" when it is clicked. Can this be done?