The following tables should do it...
Customer (School)
Visit (Each visit to a school)
Sale (Each Sale for a visit)
Sale Details (The details of the sale)
Visit Expenses
>My client came with the following request:
>He has a company that used to go to schools and to sale a product.
>He want to know the following information in every sale day:
>The school name, the date (he can come to same school twice a year), how many peopls paid 100$, how many paid 50$ etc, how many peopls paid by checks, how many cash...
>In addition he want to know how many bills of 100$ he got, how many bills of 10$..., and the last thing is the expenses that he had (fuel, driver etc).
>Hw want form to fill every time, and option to make totalization per period by few categories.
>I have few ways to do it, but it's looks too complicated, some on can offer me a good way to do it (what to put in tables, what to put in list boxex...)?
>Big thank you
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown