Whats the BEST way to display data?

[Paul Dudley]

Thanks for taking an interest.

I have a Clients Form with the we do for them job as seperate records. I also have a Contractor form with Contractors listed as separate records. The Contractors are allocated to the jobs on the Clients form. I bill the Contractors on a monthly basis for the work they do for these Clients.

I'm looking for an effective way to display the Contractors details and the jobs/Clients they do,(there may be many) so that I can view each job and then bill them for it.

For example a form with the following information:

Contractor name and details
Contractor I.D number

Invoice No

Jobs(from the Clients form)
1.Client Name job Cost total
2.Client Name job cost total
3.Client Name job cost total
etc
etc
Total Cost

is there an effective way that I can display all this data using the tables I already have and how can I list all the jobs allocated to the Contractor on one form using the tables I already have?

Thanks

Paul

[Paylo]

One way is to use sstabs to place multiple information on one form. Then use a datagrid or MSFlex grid to display the data from the tables.

Datagrids can be editted while MSFlexgrids cannot be edited. You'll probably use a data control for simplicity to transfer the data from the DB to your grids.

Also, in my experience MSFlexgrid doesn't work with ADO, but I hope someone can prove me wrong.

So in the end you just switch between tabs to see information from different tables. If you need any code, just ask. :)

Francis.

[P.S.W.]

If you have VB6 Professional, you might want to give the MSHFlexGrid a try (Hierarchical FlexGrid), employing it as suggested above. It works with ADO, and it will allow cells to "merge", so you can have one cell hold the Contracter data, and put it adjacent to x number of cells that hold the Client data (The flexgrid will automatically size the cells appropriately).

I recommend using the Data Form Wizard (if you have it), to test it out and see if it will fit your need.