Automated insertion of Number based on Textual value of a dropdown menu
I am new to FMP and any help would be appreciated.
I have to related tables, What Im trying to do is to insert a number in a filed in second table based on a selection from first table. Values in the first table is a text entry and they are E , L, N and LD in a dropdown menu. I want FMP to insert 7.5, 7.5, 11 and 11 into different field on the second table.
Is this possible and How???
Thank you all in advance for helpipng me