I had a solution in FM4 that I am attempting to re-create in FM10. I have 3 tables: Exhibitor Info, Classes & Charges
In the exhibitor table I have a "Date of Birth" field (dob) and a calculation field in that same table that determines their age as of Jan. 1st of the current year. This all works fine, the calculation alway has the correct value. In the classes tableI have two fields (acutally a lot more than that) a "Minimum exhibitor age" and a "Maximum Exhibitor age". In the Charges table I keep track of classes they have entered and want to make sure that they are in the correct class for their age. Anybody have any ideas ? I had this working lake a charm in FM4 but can't seem to figure it out with 10. Thanks in advance for any ideas !
