469,934 Members | 2,308 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,934 developers. It's quick & easy.

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

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??
May 21 '20 #1
5 1700
Luuk
1,044 Expert 1GB
"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??
May 21 '20 #2
Thanks alot Luuk!!!

So any suggestion to do that?
May 21 '20 #3
twinnyfo
3,653 Expert Mod 2GB
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!
May 21 '20 #4
NeoPa
32,232 Expert Mod 16PB
So would I ;-)

The counting would be done in a Query of course.
May 22 '20 #5
k thanks a lot guys!
May 22 '20 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by prabhukumarasamy | last post: by
3 posts views Thread by vonclausowitz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.