MSHFlexgrid Bands

[caconner]

I've never used flexgrids, or multiple hierarchies for that matter, and need some help. The database is in Access 2000 and I'm using ADO to connect.

I want to display info in a check register layout, similar to the one found in Quicken. When the user selects an account name from a list box, the flexgrid populates - 2 rows/bands for each record. I think I need to use bands so that I can customize each band's appearance (color, etc). The first band contains info from my checking table, so its not much of a problem.

The second band will only have 2 pieces of data - CatName and Memo. The Memo field is in the Checking table. CatID is found in both tables to relate the 2, but I want to display the CatName from the ExpenseCategory table, not the CatID. To make things as complicated as possible, I want to display based on the seelcted acct number, but not display it.

I've tried joins and the shape commands, but only know enough to completely confuse myself. Any help would be great!

Cathy

 

[Guest_imported]

Hi Cathy,
Are you using queries to populate your Flex Grid? Please send us more info about the structures of the tables that are involved. This will make the task a lot easier.

 

[caconner]

The 2 tables I'm using to populate the mshflexgrid are Checking and ExpenseCategories.

Checking w/ the following fields:
TransID (PK)
CheckNo
Payee
Date
Clear/Uncleared
Amount
AcctNo
Balance
AcctTypeID (FK)
CatID (FK)

ExpenseCategories w/ the following fields:
CatID (PK)
CatName
CatDescription

I think I need to create 2 bands of info. The first band to include Date, CheckNo, Payee, Amount (separated into 2 columns - Payment or Deposit - based upon whether the Amount value is positive or negative), and Balance.

The second band is only going to contain 2 fields from the 2 different tables. Memo from Checking. CatName from ExpenseCategories.

I tried a join and shape command, but get an error message about a required field is missing. Am I attempting the impossible? After I get the info set up in the mshflexgrid, I'll make it fully editable w/ a text and combo box.

Thanks
Cathy

 

[caconner]

ok... i figured out what i was doing wrong with the shape statement, but now i have a different question.

can you programmatically assign 2 recordsets to mshflexgrid bands without using a Data Environment?

Cathy