Newbie requiring help with hyperlink function please

[chieflx]

Hi everyone,

As the title implies I am a complete novice, but I have decided to try and build a database which lists every member of my family. It is so I can track who and what I have added to my family tree. I have designed a form which appears to work reasonably well for my needs but I want to link to various saved files (census information, birth records and so forth) that are stored as separate files. I have created a field in the form called 'links' and I would like to be able to use hyperlinks to open these various files. I have search on this forum but cannot find the answer to a particular problem I have encountered. Is it possible to have multiple hyperlinks in one field? I realise that I could create multiple fields but not every record needs each external file and also the number of external files grows as I find new information (which I assume means I'd have to redesign the form every time I wanted to add a new field).

If it is not possible to have multiple hyperlinks would I be able to use a list box so I could see the complete list of files and just select the one I want? If this is a possible solution how do I create such a box?

Although I can follow wizards and simply instruction I get completely lost when talking about or trying to understand/work with code, so if anyone knows a simple solution they would be willing to share I would be very grateful.

Many thanks
Rob (chieflx)

 

[missinglinq]

I realise that I could create multiple fields but not every record needs each external file

What you're describing here is a classic One-to-Many relationship; One Record can have Many links. The usual way to address this type if situation is to use a second Table and a Subform on your Main form.

The Table for the Main form would have Fields for whatever ID information (Name, DOB, Mother, Father, etc) you use and a Field that is unique to that particular Record.

The Table for the Subform would have a Field for the link and the same unique Field as it's Main form Record.

The Main form and Subform would be linked on the unique identifying Field. You create as many or as few Records as you need for a given Record on the Main form. As you move from Record to Record on the Main form, the appropriate link or links would then appear in the Subform.

You can also use the Subform to add or take away links from a Record at any time in the future.

Linq ;0)>

 

[chieflx]

Thank you for the help Linq, would this work even if most of the files I want to link to are saved web pages.

Chieflx

 

[missinglinq]

How/where the links are displayed shouldn't effect their functionality.

Linq ;0)>