I’m customizing the Invoices-template for my specific needs. In the products-table I have seven different price options for every product, each with a name, such as ”weekend price”, ”monday price” etc ...
In the invoices-table I have one pulldown menu field with a valuelist of the pricing option names.
How do I get the corresponding price option from the products-table to appear in the unit price field in the invoices-table when I choose the option from the pulldown menu value list?
If ”price name” is ”monday price”, then price is xxx$.