A2007 Hyperlink

[JimS]

A2007 allows multiple hyperlinks in a single column. I want to update a
hyperlink column with some additional hyperlinks. The column may or may not
be null. It may have a hyperlink in it I want to add to .

What's the process? I know how to do an update query, I just don't know how
to structure the column. Do I just use the ampersand operator and update the
column that way, or do I need to place a separator between hyperlinks?

 

[JimS]

While I generally agree with you that I wouldn't normally use a multivariate
capability, I think this is a reasonable exception. I see no time when I'd
want to search the column, and I do see that multiples make sense. MS has
made it quite easy to do, at least manually.

I could make it a "child" table, but I'm not sure it's worth the trouble.

 

[JimS]

I've reconsidered. It wasn't as easy as I thought, and it's not that hard to
have a secondary table. The secondary table could even save disk space. Thanks