We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MS Access: Table Relationships

James Coats
James Coats asked
on
Medium Priority
339 Views
Last Modified: 2012-05-11
I would like to adjust my table relationships so that the following happens:

Tool List is the Master Table

All other tables are slaves.

I have inherited this from someone else so I am working through this.

The ID’s in the other tables are from the “Tool List” ID but were just named “ID” in that table. Should I change that? To “Instrument ID”??

Also the “Tool List” table has a “Type of Device” field which identifies what each instrument it via a description.

I want to put that field as it related to the slave tables such as Temperature, Deflection, Dimension so that respective table will only see or accept data from the Master table that is related to itself.

Can someone give me an example of how to do this. I then will make Forms that relate to each slave table that will accept data related to itself.



Measuring-Instruments-2Rev.mdb
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
James CoatsComputer Info. Sys. Student

Author

Commented:
Thanks guys that really helped.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.