help with uniforms

I have a database, I use for ordering uniform and keeping a check on
employees allocation.

The company we use to supply the uniform have changed their pricing structure,
which is causing me a few problems.

Any outsize orders are liable for a 10%, 20% , 30% or 40% mark-up

At the moment all my prices are generated when you pick an item from a combo
box, it automatically fills in the price.

The size is input by the user.

Because of the pricing changes and the sizing differences with my stock:

Shirts 14� –22�
Blazers 34� - 58�

I was hoping to have a combo that recognises the 14� – 18.5� price and also
recognises when the user clicks on 19� – 22� and automatically updates with
the 20% surcharge on those sizes.

I would also need, when the user picks for instance, ‘blazers’, the size
combo box changes to reflect the difference in sizing from shirts.

On Thu, 06 Sep 2007 09:25:41 GMT, "johncarless" u37208@uwe wrote:

I have a database, I use for ordering uniform and keeping a check on
employees allocation.

The company we use to supply the uniform have changed their pricing structure,
which is causing me a few problems.

Any outsize orders are liable for a 10%, 20% , 30% or 40% mark-up

At the moment all my prices are generated when you pick an item from a combo
box, it automatically fills in the price.

The size is input by the user.

Because of the pricing changes and the sizing differences with my stock:

Shirts 14” –22”
Blazers 34” - 58”

I was hoping to have a combo that recognises the 14” – 18.5” price and also
recognises when the user clicks on 19” – 22” and automatically updates with
the 20% surcharge on those sizes.

I would also need, when the user picks for instance, ‘blazers’, the size
combo box changes to reflect the difference in sizing from shirts.

Since we have no way to see your screen, and you haven't posted anything about
the structure of the tables containing this information, there's really no way
to answer the question. The combo can't "recognize" anything - you'll need
some indication *in a table* about the mark-up. Perhaps the table of sizes
could have an additional field storing the markup for that size.

For the second question, you can base the Sizes combo box on a query which
references the control which lets the user select shirts or blazers. Again,
since I can't see your form or your table, I can't be specific, but the query
could be something like

SELECT size fields FROM SizeTable
WHERE SizeTable.ClothingType = Forms!YourFormName!SomeControlName
ORDER BY some reasonable set of fields;

You'ld choose "Shirts" or "Blazers" (or "Sport jackets" or "Overalls" or...)
from SomeControlName and the size combo would then reflect that choice. You
will need to Requery the size combo in the after update event of the first
control.

John W. Vinson [MVP]