S
Senexis
Hello,
How do I get a table of inventory data to go from looking like this:
[Stk Nmber].....[UI].....[ITEM NAME]................[O/H].......[IC_Group]
005643780.......EA.......LAMP, HOUSING.................1........0152A
005644783.......EA.......REMOTE, CONTROL...............0........0924B
005644784.......EA.......TV CASE, BLACK, P/N 4902......1........0816D
005654789.......EA.......TABLE, OAK 3. x 5.............1........
005655436.......EA.......HINGE, ASSY...................3........
006655538.......EA.......BOOK, DISPLAY, RED............3........
006656402.......EA.......RUG, DISPLAY, BLUE............1........
006656406.......EA.......CHAIR, OAK....................2........
007665759.......EA.......CUST SAMPLE...................2........
009683469.......EA.......TV CASE, RED, PN 7503.........1........0816D
013704547.......EA.......REMOTE, CONTROL, LARGE........6........0924B
015718722.......EA.......FOOTSTOOL, BIRCH, 3. X 5......6........
015733146.......EA.......FRUIT, DISPLAY................0........0451C
016733159.......EA.......LAMP, HOUSING, BRASS..........4........0152A
018749717.......EA.......FRUIT, SMALL..................1........0451C
018756024.......EA.......CENTER, STONE.................0........
to this and/or in a report to print out:
[Stk Nmber].....[UI].....[ITEM NAME]................[O/H].......[IC_Group]
005643780.......EA.......LAMP, HOUSING.................1........0152A
......016733159.......EA.......LAMP, HOUSING, BRASS..........4........0152A
005644783.......EA.......REMOTE, CONTROL...............0........0924B
......013704547.......EA.......REMOTE, CONTROL, LARGE........6........0924B
005644784.......EA.......TV CASE, BLACK, P/N 4902......1........0816D
......009683469.......EA.......TV CASE, RED, PN 7503.........1........0816D
005654789.......EA.......TABLE, OAK 3. x 5.............1........
005655436.......EA.......HINGE, ASSY...................3........
006655538.......EA.......BOOK, DISPLAY, RED............3........
006656402.......EA.......RUG, DISPLAY, BLUE............1........
006656406.......EA.......CHAIR, OAK....................2........
007665759.......EA.......CUST SAMPLE...................2........
009683469.......EA.......TV CASE, RED, PN 7503.........1........0816D
......005644784.......EA.......TV CASE, BLACK, P/N 4902......1........0816D
013704547.......EA.......REMOTE, CONTROL, LARGE........6........0924B
......005644783.......EA.......REMOTE, CONTROL...............0........0924B
015718722.......EA.......FOOTSTOOL, BIRCH, 3. X 5......6........
015733146.......EA.......FRUIT, DISPLAY................0........0451C
......018749717.......EA.......FRUIT, SMALL..................1........0451C
016733159.......EA.......LAMP, HOUSING, BRASS..........4........0152A
......005643780.......EA.......LAMP, HOUSING.................1........0152A
018749717.......EA.......FRUIT, SMALL..................1........0451C
......015733146.......EA.......FRUIT, DISPLAY................0........0451C
018756024.......EA.......CENTER, STONE.................0........
What I want to do is take a table of inventory data, with Interchangeable
Groups ( [IC_Group] ), and make a report that I can use out in the shop to
quickly look up by the [Stk Nmber] and find all other records that have the
same [IC_Group]. Doing this will of course increase the count of records,
but I'm looking for a very fast way to see all the data I need, and find all
the other interchangeable items at the same time without having to look at
another listing.
I also intend on formating the result so it looks a better and a little
easier to read that the above example.
Thank you!
How do I get a table of inventory data to go from looking like this:
[Stk Nmber].....[UI].....[ITEM NAME]................[O/H].......[IC_Group]
005643780.......EA.......LAMP, HOUSING.................1........0152A
005644783.......EA.......REMOTE, CONTROL...............0........0924B
005644784.......EA.......TV CASE, BLACK, P/N 4902......1........0816D
005654789.......EA.......TABLE, OAK 3. x 5.............1........
005655436.......EA.......HINGE, ASSY...................3........
006655538.......EA.......BOOK, DISPLAY, RED............3........
006656402.......EA.......RUG, DISPLAY, BLUE............1........
006656406.......EA.......CHAIR, OAK....................2........
007665759.......EA.......CUST SAMPLE...................2........
009683469.......EA.......TV CASE, RED, PN 7503.........1........0816D
013704547.......EA.......REMOTE, CONTROL, LARGE........6........0924B
015718722.......EA.......FOOTSTOOL, BIRCH, 3. X 5......6........
015733146.......EA.......FRUIT, DISPLAY................0........0451C
016733159.......EA.......LAMP, HOUSING, BRASS..........4........0152A
018749717.......EA.......FRUIT, SMALL..................1........0451C
018756024.......EA.......CENTER, STONE.................0........
to this and/or in a report to print out:
[Stk Nmber].....[UI].....[ITEM NAME]................[O/H].......[IC_Group]
005643780.......EA.......LAMP, HOUSING.................1........0152A
......016733159.......EA.......LAMP, HOUSING, BRASS..........4........0152A
005644783.......EA.......REMOTE, CONTROL...............0........0924B
......013704547.......EA.......REMOTE, CONTROL, LARGE........6........0924B
005644784.......EA.......TV CASE, BLACK, P/N 4902......1........0816D
......009683469.......EA.......TV CASE, RED, PN 7503.........1........0816D
005654789.......EA.......TABLE, OAK 3. x 5.............1........
005655436.......EA.......HINGE, ASSY...................3........
006655538.......EA.......BOOK, DISPLAY, RED............3........
006656402.......EA.......RUG, DISPLAY, BLUE............1........
006656406.......EA.......CHAIR, OAK....................2........
007665759.......EA.......CUST SAMPLE...................2........
009683469.......EA.......TV CASE, RED, PN 7503.........1........0816D
......005644784.......EA.......TV CASE, BLACK, P/N 4902......1........0816D
013704547.......EA.......REMOTE, CONTROL, LARGE........6........0924B
......005644783.......EA.......REMOTE, CONTROL...............0........0924B
015718722.......EA.......FOOTSTOOL, BIRCH, 3. X 5......6........
015733146.......EA.......FRUIT, DISPLAY................0........0451C
......018749717.......EA.......FRUIT, SMALL..................1........0451C
016733159.......EA.......LAMP, HOUSING, BRASS..........4........0152A
......005643780.......EA.......LAMP, HOUSING.................1........0152A
018749717.......EA.......FRUIT, SMALL..................1........0451C
......015733146.......EA.......FRUIT, DISPLAY................0........0451C
018756024.......EA.......CENTER, STONE.................0........
What I want to do is take a table of inventory data, with Interchangeable
Groups ( [IC_Group] ), and make a report that I can use out in the shop to
quickly look up by the [Stk Nmber] and find all other records that have the
same [IC_Group]. Doing this will of course increase the count of records,
but I'm looking for a very fast way to see all the data I need, and find all
the other interchangeable items at the same time without having to look at
another listing.
I also intend on formating the result so it looks a better and a little
easier to read that the above example.
Thank you!