Solved

Creating a default found set from inputted field values

Posted on 2007-11-22
18
226 Views
Last Modified: 2010-04-27
I have a produce table that records certain values for each of my supplier's produce. Most of this produce supplied is used to populate a vegetable box that is delivered to our customers. (But not all of them... )

Our vegetable box sizes are small, standard and large: in our produce table I have three fields. One is called small, one is called standard, and one is called large. In each I enter the weight amount/quantity amount of the produce I would put in the corresponding boxes: ie 1lb in a small box, 1.5lb in standard box, 2lb in a large box.

Then when a customer places an order, I enter generic details, including the size of Vegetable box they've ordered. I also have further details for their order which is a found set made up of all the produce we are supplied. Here I can enter the quantity amount of each produce ordered: this gives me the opportunity to customise vegetable boxes should our customers dislike a particular vegetable, or they want more of one, compared to another.

The point is, can I get the quantity amount in the more specific details to originally default to a small box size, standard box size, or large, depending on what the customer has ordered, with the ability to change  the quanity if needed?

If I haven't explained well enough, please tell me, and I will try to elaborate!
0
Comment
Question by:butterhook
  • 12
  • 6
18 Comments
 
LVL 28

Expert Comment

by:lesouef
ID: 20338287
yes, of course...
create a field box_size in customer_order_lines.
create a list boxes = small, standard, large
assign this list to the box_size field, as popup menu.

make the qty field auto-enter/calculated/do not replace.... (this last one if you want to avoid further change of the qty if you hit the box_size popup after qty has been entered.)
field calc:
Case (
box_size = "small" ; produce_in::qty_small ;
box_size = "standard" ; produce_in::qty_std ;
box_size = "large" ; produce_in::qty_large ;
0
)

BTW, who makes the boxes? you or the supplier? if the supplier, you'd better not change the qty but change the amount of boxes?
As usual, I have an example, based on your previous file, I can send it to you if you fail in doing this. but that's pretty easy.
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345117
Lesouef, sorry for the delay - have been up to my eyeballs as it were - and have only had a chance this morning to get on with this problem...so I will try as you suggested, and get back to you if there's any problems... thanks for the swift reply...
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345141
Lesouef, shouldn't I be creating the box_size field in customer orders - and not customer_order_lines, as otherwise, the box_size field is going to be present for each produce listed...
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345248
I seem to be getting closer, but quantity still isn't populating with the correct quantity amounts...
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345250
And another thing: how can I get it to repopulate the quantity amount if a customer calls to ask to upgrade her small box to large? Oh, so many questions!
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345268
Can you post your example Lesouef so I can see where I went wrong. I just can't seem to get the quanity amount to get calculated...
0
 
LVL 28

Expert Comment

by:lesouef
ID: 20345295
if the box-size is in the customers_orders_lines, it is because I thought you could order a small box of carrots and a large box of beans in the same order; so what? customers must use identical box sizes for the items of a given order? not very logic to me...
repopulation: so far, you can alter the qty after the box size has been set. if you change the box size again, I have prenvented qty to change again, in case you would hit the box size again by accident, and thus overwrite the custom qty you may have entered in between. this can change for a dynamic behaviour, ie any box-size change overwrites the qty. I could even enable in this case qty to be overwritten only if the qty matches any of the available box-sizes and disable it for an existing custom qty. that is not in the current example. just tell me, I can't decide for you, this is really a user's decision depending how you handle customer orders.
file: https://filedb.experts-exchange.com/incoming/ee-stuff/5799-butterhook5.zip
0
 
LVL 28

Expert Comment

by:lesouef
ID: 20345317
Just modified the exmaple for the last thing mentionned which seems the most logic to me. not sent to you yet.
One thing: if you alter the qty in a box, how can you stuff the veegees in there ? or do you always lower the default value? and why not choose the box from the qty by choosing the box size which gives the least amount of boxes? (may not suit the customer...)
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345391
Just so you understand, the way it works is that our customer either orders a small, standard, or large vegebox size...we place a selection of seasonal vegetables within it without our customer having control of that. They can however state two dislikes, and we then make up the difference. Furthermore, they can order extras, which we then add to their order... so if they order a small box, I want the quantity amount of each vegetable we place in a small vegebox to be automatically populated. This can then be edited if they dislike it... do you see what I mean?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 1

Author Comment

by:butterhook
ID: 20345465
The point is, we don't supply a box full of just carrots, or potatoes, or leeks etc. We supply a box full of seasonal vegetables, with all sorts of vegetables in it. But if it's a small box, we only put small_quantity of lbs in the box, if its standard, we only put standard_quantity of lbs, and large, large_quantity amount...

I'm sorry if I haven't explained it well enough, but I'm sure you've got a better understanding of what's best than I do! You normally do!
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345557
Lesouef - what you have done is great! I think I just didn't explain full enough... the point is that for each customer_orders_lines, there will only be one vegebox size. If in customer_orders_new, vegebox_size is small, then for customer_orders_lines every produce will default to qty_small. Is that more clear?
0
 
LVL 28

Expert Comment

by:lesouef
ID: 20345749
ah, you are mixing the whole stuff in a single box!!!!!!!! why don't you make the soup strait away!
so...
please wait, I have to review the whole process...
One box fits all !!!!!!!
Still afraid the beans bet smashed by potatoes...
0
 
LVL 1

Author Comment

by:butterhook
ID: 20345775
Ah - you are astute lesouef - we have compartments for such occasions - fancy a job packing boxes! He he he!
0
 
LVL 28

Accepted Solution

by:
lesouef earned 500 total points
ID: 20345887
> fancy a job packing boxes?
I am still probably better on databases, but I might end up doing that very soon...

now modified according the latter explanation, ie the box with the "avoid the mess compartments"!
https://filedb.experts-exchange.com/incoming/ee-stuff/5802-butterhook6.zip
0
 
LVL 1

Author Closing Comment

by:butterhook
ID: 31410890
Quite brilliant!
0
 
LVL 1

Author Comment

by:butterhook
ID: 20346987
Absolutely marvellous once again Lesouef...
My quest now is to ask a question that you can't answer! He he he. I think I'm going to find that difficult!
0
 
LVL 28

Expert Comment

by:lesouef
ID: 20347233
I know the answer to that too!
0
 
LVL 1

Author Comment

by:butterhook
ID: 20347278
he he he - expect to hear from me soon!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Migration of Exchange mailbox can be done with the ExProfre.exe tool. But at times, when the ExProfre.exe tool migrates the Exchange Server user profile, it results in numerous synchronization problems. Synchronization error messages appear in the e…
Step by step guide to Clean and Sort your windows registry! Introduction: Always remember: A Clean registry = Better performance = Save your invaluable time In this article we're going to clear our registry manually! Yes, manually! The e…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now