Multiple hperlinks within a single field

[Jason_G]

Hello all. I am designing my first somewhat complex database in Access 2000 and I have run into a problem with hyperlinks. I am using this database to house rules and regulations as records. Within each record I have a hyperlink field to our corresponding policy or procedure (Word doc.) on our company Intranet. When there is one policy or one procedure, it works fine. Unfortunately we have several policies and procedures that need to be accessed for each record. Right now I can only use one hyperlink per field within a record. For organization's sake I would like to use multiple hyperlinks within the same field to take the user to any of the corresponding documents. Can Access do this? If so how?

Any help is greatly appreciated.

Jason

 

[dcx693]

Create another table just for the hyperlinks and relate it to your curren table/query by each rule and regulation. That would create a one-to-many relationship between the main table (your current one) and the table with the hyperlinks to each document. The hyperlinks would not all be in one field, but you could display them on a form in a list or combo box.

 

[Jason_G]

Very good. Worked on a few test policies this morning.

Thanks for your help.

Jason