This content has been marked as final. Show 2 replies
Ok, I've figured out how to create a new layout, organize into groups by box, and then print in 9 columns. But this only works when I preview or print! How do I make columns in the layout itself?
You are right: you need a portal, based on a relationship that matches the selected rack (in a global field) to the slot's rack (and also the storage unit - if you have more than one).
This way there will always be 81 related slot records. Create a portal of 9 rows, and duplicate it 8 times. Set each instance to start at the appropriate row (1, 10, 19, 28, etc.).
To ease the sorting, give each slot a serial number. The slots will show in a "down first" pattern - and you can calculate the row and the column from the serial number using Div() and Mod().