AnsweredAssumed Answered

Manage banding pricelist

Question asked by CsabaMarácz on Oct 26, 2014
Latest reply on Oct 26, 2014 by philmodjunk


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