Just a quick simple question regarding Access 2007 relationships. I'm super green to this stuff - just spent about a week on it. I'm a little confused when it comes to how the database should be set up. What I've read is that I shouldn't have data in multiple table, however I've also read that when data is repeated it should have it's own table... I don't understand what I just typed, so I understand if you don't.
To the point. All I'm looking for is whether the attached screen shot of my relationship set up looks accurate of out to lunch.
I will accept the answer 'accurate' or 'out to lunch' - If the answer is 'out to lunch', which I'm assuming it will be a brief explanation as to why would be appreciated.
The reason I'm awarding 500 points is because of the read you just did - and the explanation if 'out to lunch' needs to be understood.