Relationships

[DFeil]

Hello,

I am a database newbie, we are making a database to track housing maintenance. We would like the database to be able to generate a report with upcoming maintenance items due based off of the Unit Number. I have created 5 tables with relationships as follows;






How do it get it working correctly? Please let me know if you require more information. Thanks in advance for your help...


Dave

[alansidman]

You should be joining your tables on Primary Keys and Foreign Keys. It appears that you have no Foreign Keys. What you have will probably not work. Suggest you read this white paper on DB design. It is only a couple of pages but very informative.

http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf

[DFeil]

You are correct, I have no Foreign Keys, I will read the white paper. Thank you.

Dave