Hyperlinks

[mura]

I have a simple form, currently with one field (see attached). For each record on the form, I would like to add 10 text boxes that would allow me to hyperlink to various places -- Internet, network directory, etc. In other words, when I click on record #5 for example, I would see a list of 10 boxes with hyperlinks that are different from record #3. Is there a way that this can be done for EACH record? Thanks in advance for your help.

 

[ecniv]

Create Ten hyperlinks (labels)
Tables (just so you can test):
MainID - Auto
MainDescription - text - 50

HyperlinksID - auto
MainID - long
Count - number (0-9 or 1-10)
Hyperlink - text - 255


For each main table (rename as appropriate) you have up to 10 hyperlinks stored in the sub table.

The form filters on the main table first (have a textbox search or something) and a button to search. Then the bottom ten links get made visible if there is a link available. Code a loop through the second table (hyperlinks) filtered by the main table, and set the label to visible, and set the hyperlinkaddress property to that returned.

As I don't know how you are likely to use it, this all I can help with, but if you get something together and need a little help, post up and someone is sure to come to your aid.


Vince