Recent content by Poagman

Bada-Bing Baby!!! That's the missing link I have been stuck on! PK=Searched part number (resides on the master table) FK(1)=Foreign table data to show as sub-item for searched part (PK) within subform i.e. Parts the searched item reports to FK(2)=Foreign table data to show as...

RE: I only linked ID's. Reply: I linked Primary keys from each table, not parent/child ID (Sorry). I'm still too new to this to really get what this is saying. - Should main tables PK link to ParentID and separately to ChildID columns on the new tables or is PK to PK correct? I think I...

I just opened up the T_PartsMaster table and see it has "expanders" to view ParentPartID and ChildPartID on same row. I really need a Parent category and a Child category that can be expanded separately. ParentID + ParentPartID - Main Item-1 - Main Item-2 + ChildPartID -...

Thanks again. I really appreciate it and am trying these as we go (not a wasted effort). I have two tables: T_PartsMaster: - ID: PK - Part Number - Description - Ect... T_ParentChild: - ID: PK - ParentPartID - ChildPartID Next Steps? I only linked ID to ID (is that correct?) I...

Thank you for replying!! I do have auto-number key on table I do have more than one parent for most items (i.e. Muffler can be part of 3 cars or a stand-alone replacement item) If I had a column referencing the ID# of the parent items I would need query criteria to DLOOKUP the ID as *ID* to...

Knowledge: Novice. Can build basic tables, queries, and forms using point & click options OK. No coding so far. Source Data: - One Table with 7900 rows and 20 columns - List of [PartNumber] and columns of specifications - Can add column "Reports to" or "Parent of" if...

Hey Hey, just coming by to hopefully find some advice from the Guru's here. Wish me luck!