B
Bill Phillips
I have a warehouse application that I need to assign a location to put away
my inventory for an incoming shipping container. The container may have 1 or
more items in it. The inventory for a single item may take up 1 or more
warehouse locations. I have locations that can accomodate 1, 10 or 15 pallets
and need to evaluate where to put my inventory based on these parameters. I
need the locations to be assigned immediately so I do not use them again. I
think I can figure the logic for this section of my problem. My basic problem
is how do I step through each item?
Is is better to create a table with the item info in it or simply use a
query as the basis? If I can get started on the loop needed for the item I
think I can imbed the logic to assign a location and use a SQL insert
statement into my inventory table.
Thanks in advance
my inventory for an incoming shipping container. The container may have 1 or
more items in it. The inventory for a single item may take up 1 or more
warehouse locations. I have locations that can accomodate 1, 10 or 15 pallets
and need to evaluate where to put my inventory based on these parameters. I
need the locations to be assigned immediately so I do not use them again. I
think I can figure the logic for this section of my problem. My basic problem
is how do I step through each item?
Is is better to create a table with the item info in it or simply use a
query as the basis? If I can get started on the loop needed for the item I
think I can imbed the logic to assign a location and use a SQL insert
statement into my inventory table.
Thanks in advance