0

One to many link [RESOLVED]

Jet Reports Historic Posts

January 27, 2012 05:39

None

Follow

I am trying to create a materials planning sheet, which lists BOM's.

I want to use the Item table as the primary table, linked to the BOM components table. The Item table has 2 filters:
- Bill of Materials = TRUE
- Reorder quantity >0

I link the component table, and select the fields Line no, No., Description, Quantity per

When I run the report, it only returns the first line of the BOM. How can I get Jet to give me all the BOM components?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 27, 2012 21:53

  Whenever linking a header/summary and detail table together, the NL(Table) will include up to one row for each record in the primary table.
  
  Thus, if you want to see detail information, you must add the detail table(s) first and the header/summary table (in this case the Item table) afterward.
  
  In this way, you can get more than one line per Item.
  
  -HP