Solved

Creating a default found set from inputted field values

Posted on 2007-11-22
18
230 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
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
 
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Sometimes people don't understand why download speed shows differently for Windows than Linux.Specially, this article covers and shows the solution for throughput difference for Windows than a Linux machine. For this, I arranged a test scenario.I…
If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine. Here is how to get rid of this: Click Start Clic…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

627 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