Is it Possible create a sub-field or a table from a field ???

[Bishrul]

Scenario - (while transporting live chicken from supplier to wholesale customer)chickens will be loaded into boxes then to the truck, so each box has a different quantity of chickens Ex- Box 1 - 11 Chickens
Box 2 - 16 Chickens etc..
each an every box must be entered individually not as whole quantity, So is it possible to have field where the total boxes will be mentioned and within that field to have the record of individual boxes??

[Luuk]

"So is it possible to have field where the total boxes will be mentioned and within that field to have the record of individual boxes??"

No, that is not possible, because then you will be storing two values in 1 field.
1) where the total boxes will be mentioned
2) have the record of individual boxes??

[Bishrul]

Thanks alot Luuk!!!

So any suggestion to do that?

[twinnyfo]

I would have a table (tblBoxes) that simply keeps track of each box on a truck: BoxID, TruckID, Chickens.

Then you count how many BoxID's for each truck, and get a sum Chickens for your total number of chickens on each truck.

Hope that hepps!

[NeoPa]

So would I ;-)

The counting would be done in a Query of course.

[Bishrul]

k thanks a lot guys!