L
LTOSH
Ok i know this is probably more simple than my mind will allow at this point
so i'm asking for help.
I have a client database that I am creating that I want to do a basic
billing/payment component. There are approximately 5 different services each
with their own cost. (For example...One-on-One Training - cost is $35.00 an
hour.) So currently i have a client table established with the following
fields:
cClientID - Autonumber
CFirstName
CLastName
*other basic demographis info*
I want to have a subform (that looks like a datasheet) at the bottom of a
client's form to show what is being charged and a payment and the current
balance.
but i want a button to click to add a new service and also a button to add a
payment.
i hope this is somewhat clear to what i am desiring...it is basically an
billing/payment that i want to create invoices for and keep up with the
accounting aspect. any help on the design of the tables would be appreciated
OR if you know where i can find a good (simple in terminology) template to
look at and learn from. All the templates i have found do not include the
payment tables and examples.
I am using Access 2002.
Thanks!!!
so i'm asking for help.
I have a client database that I am creating that I want to do a basic
billing/payment component. There are approximately 5 different services each
with their own cost. (For example...One-on-One Training - cost is $35.00 an
hour.) So currently i have a client table established with the following
fields:
cClientID - Autonumber
CFirstName
CLastName
*other basic demographis info*
I want to have a subform (that looks like a datasheet) at the bottom of a
client's form to show what is being charged and a payment and the current
balance.
but i want a button to click to add a new service and also a button to add a
payment.
i hope this is somewhat clear to what i am desiring...it is basically an
billing/payment that i want to create invoices for and keep up with the
accounting aspect. any help on the design of the tables would be appreciated
OR if you know where i can find a good (simple in terminology) template to
look at and learn from. All the templates i have found do not include the
payment tables and examples.
I am using Access 2002.
Thanks!!!