Viewing Crosstab tables in a form

[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

 

[Dominique Feteau]

Thats ok guys. I figured out to use subforms for my purposes.

niq