Access 2000 Multiple hyperlinks within a field

[Jason]

I am building my first database and I have hit a wall. I
have created hyperlink columns and they go exactly where
they are supposed to. The problem I encounter is when I
want to access multiple hyperlinks from a field within a
record. One is all I can do. What is the best way to
deal with this? Ideally I would like to have multiple
hyperlinks within a given field, but if this is not
possible, could I route the hyperlink to another table
containing multiple links?

Any help is greatly appreciated.

 

[Rebecca Riordan]

Jason,

You should never store multiple values in a single field. What you should
do instead, as you've already guessed, is create a second table with
multiple rows for each of the entities the first table represents. Create a
one-to-many relationship between the two tables.

Other than that, I'm afraid I don't know exactty what you mean by "route the
hyperlink"...

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

 

[John Nurick]

Hi Jason,

You can't store more than one hyperlink in a hyperlink field. In any
case one of the key principles of relational databases is that each
field should contain just one piece of data.

The usual "relational" way of doing this is to put the hyperlink field
in a separate table with a many-to-one relationship to the main table.
That way you can have any number of hyperlinks associated with one
record in the main table.

To display them, you'd use a form to display data from the main table,
with a subform on it for the hyperlinks. For an example of this, look at
the Orders form in the Northwind sample database: this uses a subform to
display the actual products associated with each order (no hyperlinks,
but the principle is the same).

I am building my first database and I have hit a wall. I
have created hyperlink columns and they go exactly where
they are supposed to. The problem I encounter is when I
want to access multiple hyperlinks from a field within a
record. One is all I can do. What is the best way to
deal with this? Ideally I would like to have multiple
hyperlinks within a given field, but if this is not
possible, could I route the hyperlink to another table
containing multiple links?

Any help is greatly appreciated.

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.