Linking records

[Joe_A]

I currently have a db that is kind of based on a asset tracker. I have a table that stores items by part number. I am trying to link records. I will try to put this in simple terms because I have a hard time using my DB to give examples. Example " in my db I have a toy truck with a part number 123. In that truck part number 123 we used a bunch of parts to make it like the wheels are part number 456 and the lights are part number 789. Each of those parts that were used to make the truck have there own records and test history stored in the db but the went into the truck and I want to link them and also be able to open reports based on that link. these parts are all in the same table.

I have seen alot about linking tables but not much on linking records.
Any Ideas?

PS. access for dummies the book is trash.

[June7]

Still have to link tables. Will need another table that has records to define relationship of assembled product to its component parts.

tblProduct
ProductID (PK - this will be same as the part number from parts table)
ComponentID (FK of part number)

[Joe_A]

Sorry this has taken so long to get back to this but we have made some major changes at work and have not had the time to get back to this but now I have time. I am not sure what you mean. I think my problem is I don't fully understand relationships. Do you know where I could find some really good reading on this subject.

[June7]

Start with the 'sticky' thread tutorials at top of this forum http://forums.aspfree.com/microsoft-access-help-18/