Tom
I think the answer to this is going to depend on the process you use
(or want to use).
If I assume that you create a Charges record every time an Exhibitor
joins a Class, then you'd most likely want to check that the selected
Exhibitor is eligible for the Class before creating the Charges
record. Would that be correct?
One way would be to display, in a layout in Exhibitor, a portal
showing all Classes that the person is eligible for. The relationship
used for the portal could be quite simple. You'd just need a two
criteria relationship:
Date of Birth > Minimum exhibitor age
Date of Birth < Maximum exhibitor age
The portal row would incorporate a button that runs the Charges record
creation script.
Does that help to get things started?
Steve
On Oct 11, 2009, at 5:14 PM, Tom Gear wrote:
> 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 !
