I am tracking a number of experts and a number of cases. These experts repeatedly show up in different cases. There is always more than one expert in a case.

This seemed like an opportunity to put the experts (names, expertise, CVs) in one database and the cases (party names, attorneys, court) in another and link on the expert name. But you can't have multiples in the link field...

What would be the logical common field that would allow multiple experts per case? Or do I need to turn my thinking upside-down?

Also, I have the experts' CVs in their record as hyperlinked PDFs (not images). I can pull the hyperlink address from the secondary DB but it loses it's hyperlink characteristics even though my form is set to treat it as a hyperlink. Can this be done? Thanks Grady