I am a keen beginner. I can usually manage to make something work, but being completely self-taught, it rarely the most efficient.
I am struggling with one problem. I have one database where i keep a list of people, all of whom appear as either the 1st, 2nd, 3rd or 4th member of various committees (number field linked to autonumber ID in people table). I need to keep a note of which position. I started with the idea of having a single list of people, and then multiple relationships. First to committee position 1, then to posn 2 etc. No matter what I tried, I could not make this work..
As a solution, I copied the people table to create 4 identical copies of the table. I could then create relationships between each committee posn and the list of members. As there were not too many people, this did not create too much of an overhead. I now have similar prob, with a far larger list of names, and I'm sure it can be done better.
Any suggestions would be welcome.