Results 1 to 2 of 2
  1. #1
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Location
    Providence, RI
    Posts
    74

    Line item dependencies


    Hello all,

    I have a table LineItemsT which essentially looks like a standard Profit & Loss statement. Each line item may or may not depend on another line item. For example, the "Gross Margin" row depends on the "Cost of Goods Sold" and the "Gross Revenue" rows. That's easy to track using a junction table. Here's the issue: I need to be able to display all of the items that depend on the current item, which means that I need to go a level deeper to see what depends on those items, and so on. Right now it's just a mock up so I don't have code to share, but I am hoping the following picture explains what I'm trying to do. Basically, the idea is that when you double click on something from the Line Items listbox, it's going to record that item in the junction table. I either need to record all levels of dependents, or I need to be able to pull a query that shows all levels of dependents. Alternatively, I could populate a listbox by adding each item using loops in VBA. All that matters is that I ultimately need to be able to see the results highlighted in orange below, one way or another.

    Click image for larger version. 

Name:	Tracing Dependencies.JPG 
Views:	6 
Size:	131.0 KB 
ID:	35876

  2. #2
    mcucino is offline Advanced Beginner
    Windows 8 Access 2016
    Join Date
    Jul 2017
    Location
    Providence, RI
    Posts
    74
    Well, as usual, describing the problem in depth helped me solve it! I got this in about thirty seconds as soon as I clicked post. I'll leave it up and if anyone else wants to know how ot do this I can post a synopsis of what I did.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 15
    Last Post: 11-25-2014, 03:42 PM
  2. Add New Line Item Detail to Invoice Based on Status
    By breakingme10 in forum Programming
    Replies: 2
    Last Post: 06-23-2014, 04:04 PM
  3. Replies: 2
    Last Post: 05-07-2014, 11:16 AM
  4. Help generating line item number in order table
    By acenumber5 in forum Queries
    Replies: 18
    Last Post: 08-23-2012, 12:50 PM
  5. Line item query
    By michaeltorpedo in forum Queries
    Replies: 9
    Last Post: 05-02-2012, 01:17 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums