Hi there, I am brand new to Jet reports with hardly any training, i want to link two tables, item master with production bom, I want the items out of the master to link to the bill of materials in the production bom table, can anyone help me out on this, stressing I am a complete novice.
Thanks
Wilko
Date
Votes
2 comments
-
Jet Reports Historic Posts Assuming that the item number is the common factor
Row 1 Cell1 Rows=2, ITEM TableTable, etc Cell 2 NF(Cell1,Itemnumber) Cell3 = Cell2
Row 2 cell3=row1cell3 cell4 row,BOM, filter by bomitem = row2 cell 3
Okay in easy terms to use two files
start with the first file on one row ( use rows=2 in cell) select for what you want do a cell =cell on the matching criteria and carry that down
the second file is on row 2 and filtered by the value you do an = on
The way jet works if there are multiple items in BOM it will show those as new row
Once you get the base it's just a cast of playing with filters
I don't work with the BOM or inventory so can't give you exact field name -
Jet Reports Historic Posts Hi
Thanks for reply, attached is the design view of the fields being used, can you explain the linking again.
Sorry for being stupid
Regards
Ian
Please sign in to leave a comment.