D
Dominique Feteau
I have 4 tables that look a bit like the one below. One for each Fee
Category. Each individual table has a sub category (type a or b).
id fee cat jan feb mar apr
1 type a 0 250 175 0
1 type b 175 0 200 0
2 type a 0 0 75 125
2 type b 50 0 150 0
I created a form that has 2 tabs. One for Client info and one for billing
info. I was able to figure out how to have the client information change
according to a combo box that I have above the tabbed pages. I want the
billing information to do the same thing. I want the billing info to see
the name of the client, find the associating amount according the fee
category and month provided.
I know this sounds confusing, but seems like a logical question and i'm sure
its been done many times before.
Any suggestions?
Dominique
Category. Each individual table has a sub category (type a or b).
id fee cat jan feb mar apr
1 type a 0 250 175 0
1 type b 175 0 200 0
2 type a 0 0 75 125
2 type b 50 0 150 0
I created a form that has 2 tabs. One for Client info and one for billing
info. I was able to figure out how to have the client information change
according to a combo box that I have above the tabbed pages. I want the
billing information to do the same thing. I want the billing info to see
the name of the client, find the associating amount according the fee
category and month provided.
I know this sounds confusing, but seems like a logical question and i'm sure
its been done many times before.
Any suggestions?
Dominique