Table Relationships

[seanp]

Hello
I am trying to create a relationship between 3 tables (see pic) so that the ones on the left and right automatically update the middle one giving me all the information i need in one place.


I have attempted enforcing referential integrity but this brings back an error message "no unique index round for the referenced field of the primary table"
Any help would be appreciated but please dumb it down because some of this stuff is way over my head.
Thanks

[nacho]

hmm it would appear you are in the position i was a few hours ago.
And i've successfully created my relationships.
So basically your error message is telling you that you can only have relationships between a primary key (example of primary key in your case = "ID" or "AutoRef") from one table, in your case, for example:
"AutoRef" from the Engineer table and another field (Example of fields in your case: "Item" and "Quantity"). This other field would generally have the same name, but be in a different table. We call this foreign key. I'll show you what my relations table looks like at the moment, i've attached image.
If you want to talk this over MSN or anything, please notify me, you can send me your initial database and i will help you reconstruct it

BTW i understand you are new to databases (well it appears so from the way you've made your tables), so may i ask if this is for school or something? I can give you some links to help you understand the general idea of Access. It looks as if you don't understand what relationships are, in that case go to:

http://thoreau.dnr.state.mn.us/mis/gis/tools/arcview/Training/WebHelp/Courses/Intro/Section8/Page8-3.html

http://databases.about.com/od/tutorials/ss/relationships.htm

[seanp]

Thanks, i wanted to mess around with subforms, but i think im gonnna have to start it again. You have helped explain how to use relationships though.