I am creating a database for Conference Registrations that will keep the name of the attendee in one file, the items for which they can register in another and the actual charges and payment information (technically an invoice) in another.
The reason for this is that some attendees add things on to their registration at the last minute this seems to me to be the best way to accurately track payment and deposit information and actual numbers of attendees.
Seems straight forward on the surface, however for each event they have to register for there are two prices - a before certain date and after certain date price. Now, do I have to create a separate line item for the before and the after rate or is there some way I can get FMPro to do the math?
Currently I have my invoice set up like so:
Line_1_Quantity, Event (look up from another file), Line_1_Total.
In a perfect world I'd like to get filemaker to recognize the event chosen and based on the date I'm entering the registration form charge either the before or after price. Am I expecting too much?
ALSO, judging by the way I've set the invoice up (as noted above), is this odd? and will I have trouble making reports on how many people are coming to any particular events. I plan on making about 10 lines per invoice so I could continue on with "Line_2_Quantity, Event, Line_2_Total", etc. Is that retarded?
I've been using FMPro for about 8 years now and am completely self-taught. The problem I'm running into is that the books I read are either for entry level or experts. If I could find a template and disect it, that would be great, but I haven't found one yet.
Thanks for any help.