What kind of data is in the fields of the first table? The fields could be one row (one field) portals that when clicked on could take you to the related record in the source table. You could also create a calculation for a tooltip that shows the relevant information, or use a pop up (v.13) Little more info, or an image of what you are trying to accomplish could be helpful
Thanks for the reply. The fields hold scientific data and each of these fields needs to have an associated source or citation. This citation should be able to be entered by the user, so it can't be a tooltip unfortunately. I am more concerned about the structuring of this. If I have a join table connecting sources to another table, I can relate as many sources as I want to any RECORD (and vice versa), but it is not so easy to relate, or associate, these sources to any FIELD... I could create a table occurrence representing every field, but this does not sound like an ideal solution. I could also use a portal for every field and simply filter the results. I am not sure how to go about this and would appreciate any help from someone who has dealt with a problem like this or has any ideas.
Wow.... what an interesting challenge. I may not have the full answer here, but I may be able to point you in the right direction.
Set up a script trigger to capture the name of the field "OnObjectEnter" as a variable. Then combine the variable with the record id to create a link to the comment.
I can go into more detail if this is what you're looking for.