My reasoning behind this is that one artist can have many tracks and there can be one particular track sung by many artists ie the same song title but each artist will have their own unique recording.
Also I am not sure what is the best method of adding the data to the table sin the forms. I know how to create a main for for artists and say a linking subform for the tracks and can add data this way but isn't this more suitable for viewing the data rather than adding?
Would be interested to know how most people go about this.
Thanks in advance for your time
I created a form bound to the join table. It has two combo boxes, one for each of the two foreign keys. The source for the two combo boxes is their respective tables. When you open the form click on Filter By Form on the tool bar and select whichever one you want to select on. Then apply the filter.
For my useage, I am matching report names to report criteria, so I normally select on the report name. I have never tried to filter on the criteria so I'm not sure how that would work.