I'm told Filemaker is the promised land of databases but I seem to stumble before entering: in Excel a function 'data validation' allow you to associate a drop menu of choices via an equation of nested if, then's to a number. E.g. a dropmenu of heart rates <60, 61-70,71-80,>80 needs to be associated with numbers 1,2,3 or 4 - which is later to be summed with other numbers from other drop menus to create a 'risk number'. How to do it?
Please let me in,