var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Problems with 2 fields and working them together
At the moment I have a database which has a value list in (pop down menu)
when I select one of the items in the list I want it give a value in another field i.e. a price.
The value list has
So say I selected A4 in the other field I want it to say £x.xx
I have tried loads of things but nothing wrks please can some one help me Im new to filemaker pro
Re: Problems with 2 fields and working them together
*You need a 'item' database in it 2 fields 'itemid' and 'price'.
*And a 'order' database 2 fields 'itemid' and 'price'.(yes the same).
in the 'item' database put a record for each value.
itemid | price
In the 'order' db create a relation ship to the 'item' database connecting item to item.
Make a pull down on 'item' in the order db that uses the 'item' field in the item database.
then in define fields of order set price as a lookup with your relationship and using :rice
email me for an example.