stacking boxes in store

[Waqas ali]

dear all experts.
i need really all experts attention on my request.

i have two size of boxes in my store 10 feet and 20 feet. i want to allocate them by system. how we allocate we have numbered to our store yard.

odd numbers for 10 feet and even numbers for 20 feet. numbering like 1,2,3,4,5,6...... if i put 10 feet box i will use 1,3,5..... and if i will put 20 feet
i will put 2,4,6.... these even numbers covered odd number like if i put 20 feet box on 2 it will cover 1 and 3. if i put on 4 it will cover 3 and 5. now here i want to put a query to check if 1 and 3 are occupied and i select 4 it should tell me 3 is already occupied you can not put on 4 use 6 which will cover 5 and 7.

it is like this.

2 4 6 8 10

1	3	5	7	9	11

<tbody>
</tbody>

 

[ranman256]

build a table tBoxPairs
fields:
[even]
[odd]

your data will be:
[even] , [odd]
2, 1
2, 3
4,3
4,5
etc...

then your record says it was put in slot 2, the query will pull 2 records : select * from tBoxPairs where [even] = 2
update the fields needed. (the query will mark 1 and 3)

 

[Waqas ali]

What about 3 under 4. All numbers are unique. If i write query even =2 then update 1 and 3 then 3 also come under 4. If i select 4 it will return me 3 and 5.
Kindly re think.