Not sure you are getting what I am looking for. My exact example:
I have one table that is a list of pewter miniatures I am painting. It has information related to that miniature (name, manufactuer, part number, a photo, etc).
I have another table that is a list of the various paints I have at my disposal. It has information related to the paint (name, manufactuer, part number, quantity on hand, etc).
Now I want to link the paint as I used it to each miniature. I can do this easily by creating a link on the miniature table. But as I then create each link I want to add an additional piece of information. And that is where I used the paint on that miniature and how I used it. This information does not exist on the two tables and has no meaning other than when I create that specific link. It is only in linking the miniature to the paint that I then know and can enter that. I essentially want to have an additional data field on the link.
In a SQL world, it would simply be creating a 3rd table that links the two others and it having an additional column with information specific to that link.