(sorry for repeating the entry; i didn't know where to post it!I
I'm having some trouble with something I'm trying to do in Filemaker.
I need to perform a calculation by using an auxiliar table, which is unrelated to the one in which I want the calculation field to be. That table shows the available doses in miligrams and the cost associated to each one (cost is not proportional to the dose). The problem is that I don’t know how to retrieve the cost field depending on the dose we choose; let me explain: if the doctor prescribes the 75 mg dose, I want to perform the calculation by using the proper cost (177.6237$) from the auxiliar table. I’ve tried some scripts, but I don’t know how to get to the field that belongs to the record with the dose chosen. Also, I can't do it by using a simple "If" calculation (If proposed_dose = 75; 177,6237 ; If...) because costs change with time and we prefer not to modify field properties (too complex for final users). Any idea? In Excel this seems to be so easy (just need to refer the proper cell from the proper book when writing the calculation), but not that easy in Filemaker (at least for me…).
Thanks in advance!
··· this is the auxiliar table, for the case you need it as a reference: