I have a report that is using two tables Parts and Packages. The Packages table has a field in it called ParentID, which references PartID from the parts table. So everything in my db is a part but using the packages table parts can contain other parts. My problem is trying to retrieve an associated PartNumber from the Parts table with a ChildID value found in the Packages table. There is no direct link between ChildID and PartID (this would require two tables to have multiple links betwwen them and Access doesnt like this very much) so I think I need to parse both tables all they way through and do comparisons and select PartNumber when these values become equal. Any ideas on how to do something like this. Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help retrieving indirectly associated data.
- Thread starter flepkows
- Start date
Since this is a crystal reports forum, why the comment about what MS Access doesn't like?
Also, what type of database are you working with?
If you are indeed using crystal, link the tables from PartID in the Parts tables to the ChildID in the packages Table.
This will work. I have done it countless times.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Also, what type of database are you working with?
If you are indeed using crystal, link the tables from PartID in the Parts tables to the ChildID in the packages Table.
This will work. I have done it countless times.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question