Having huge issues relating tables

[gregoryr]

I am having huge issues relating tables in access. I'm not good at access at all. I'm doing a class project and literally have been stuck for two days.....

[RuralGuy]

If you want Access to help with the relationships then you should have an AutoNumber Primary Key (PK) in each table and another field in the related table as a Foreign Key (FK) field (Long Integer) that contains the PK value from the main table.

[RuralGuy]

Can you do a Compact and Repair and then zip it up and attach it to a post? Use the Advanced Reply and scroll down to Manage Attachments.

[gregoryr]

OK I will try thanks

[gregoryr]

Here it is

[orange]

Work though this tutorial to get some appreciation of the steps involved in designing a database.
http://www.rogersaccesslibrary.com/T...lationship.zip

Good luck.

[RuralGuy]

That's a great link, Orange. Thanks!

[orange]

Glad you like it Allan. That tutorial has all the basics - in my view - and is fairly easy to follow regardless of skill level. And the nice thing is, it has a solution as well as a step by step approach.

orange

[gregoryr]

Thanks so much, it is definitely appreciated.