Dynamically structure fields

[rinelson]

Here's the table:

ID field: autonumber
ProjectID: lookup to Projects
Contractor: lookup to Contractor
ParentContractor: lookup to Contractor (this same table)

I use this to create the hierarchy of the contractors and subs on a project. I would like the table to show the structure properly -- similar to a treeview obj in a form.

Once that is done, I want to have a subreport that shows labor violations (from the laborviolations table) for each contractor (sub or general).

I'm stumped big time and now coming down to a deadline.

Thanks in advance.