R
Ricter
The tables are, for example, tblContainers and tblItems. A container may
have one or more items, so they've been related this way.
Generating the report that subdivides items by their container is easy.
What I'd like to know is how can I sequentially number the items, 1 to n,
regardless of the container they're in? That is, if I have 100 items packed
in 5 containers, I want the report to show a unique Item No. next to each
item...
Thanks
have one or more items, so they've been related this way.
Generating the report that subdivides items by their container is easy.
What I'd like to know is how can I sequentially number the items, 1 to n,
regardless of the container they're in? That is, if I have 100 items packed
in 5 containers, I want the report to show a unique Item No. next to each
item...
Thanks