Manage banding pricelist
I'am a very novice in Filemaker (and my English is also poor).
Can anyone help me, what is the right way to do the following:
I would like to manage a pricelist in Filemaker which is "banding". It means for example
1 piece of supersticker costs 10USD/pc,
10 pieces of supersticker costs 9USD/pc,
20 pieces of supersticker costs 8USD/pc etc.
Which calculation formula is able to find the right related price in related fields?
I think I make a product table with fields: Product_ID and Product_name
Than I make a table for prices with fields: product_id and quantity and price
Than I connect (relate) the Product_ID with a product_id as a one to many relationship
Than I would like to make a layout with a calculation, where I fill the product (drop down list) field and type in the quantity in the quantity field, than the right unit price automatically appear in the unit price field.
But I don't know how to make a layout, where the calculation (product quantity multiply with product price) where the correct price will appear automatically for the quantity.
Thank you for your kind help.
Best regards: Csaba