ok heres my fields I need, I'm not getting this to work for me, and I
don't know why, please tell me how I need to organize this into my
tables to function for me in my reports and form:
Field Names:
First Name Grade Tentmate
Last Name Age New Camper
Address Parent/Guardian Returning Camper - # of years
City M Work # Ethnic
State F Work # Camp Fee
Zip M Cell # Add Session Fee
County F Cell # Total Camp Fees
Home Phone Troop Level Deposit Fee
Early Bird Discount
Second Child Discount
Third Child Discount
Cookie Credit
Financial Aid
Balance Due
Payments Made
Paid In Full
Then the session information fields need to be able to reflect this information:
there is 4 sessions with 4 different programs to choose from within each one
a girl can choose more than one session, but only one program within a session
I need to be able to fill out one form for each child and pull reports that
reflect a listing of girl, program, session for the whole summer and each
session individually. So another words I need to enter most of the time more than one session and program choice, but the program must relate to the session she chose. Thanks in advance for assisting me with this problem, I had no problem getting our Day Camp set up, but this session program thing has thrown me, obviously, it's very frustrating!
don't know why, please tell me how I need to organize this into my
tables to function for me in my reports and form:
Field Names:
First Name Grade Tentmate
Last Name Age New Camper
Address Parent/Guardian Returning Camper - # of years
City M Work # Ethnic
State F Work # Camp Fee
Zip M Cell # Add Session Fee
County F Cell # Total Camp Fees
Home Phone Troop Level Deposit Fee
Early Bird Discount
Second Child Discount
Third Child Discount
Cookie Credit
Financial Aid
Balance Due
Payments Made
Paid In Full
Then the session information fields need to be able to reflect this information:
there is 4 sessions with 4 different programs to choose from within each one
a girl can choose more than one session, but only one program within a session
I need to be able to fill out one form for each child and pull reports that
reflect a listing of girl, program, session for the whole summer and each
session individually. So another words I need to enter most of the time more than one session and program choice, but the program must relate to the session she chose. Thanks in advance for assisting me with this problem, I had no problem getting our Day Camp set up, but this session program thing has thrown me, obviously, it's very frustrating!