Hi!
I've got a project database which I want to be able to present in a nice way.
In one table I've got the fields:
project no
resourceNo (person working in the project)
documentA-progress
ducumentB-progress
documentC-progress
etc..
Each project may have many persons working in it with different documents. There may in other words be several records with the same projectNo but different resourceNo.
In my report I've grouped all records working with the same projectNo together with the grouping tool (several records of different resourceNo in each). It is thus easier to separate the different projects.
My problem is that reports (as far as I know) don't allow freezing of the header when scrolling down (like in Excel). I'm told to work with forms instead.
But are there any functionality for grouping records together in forms? I don't understand how to do this.
To clarify, my data look like this:
projectNo, ResourceNo, documentA, documentB..
111, 201, xxx,xxx
111, 203, xxx,xxx
113, 201, xxx,xxx
113, 202, xxx,xxx
113, 203, xxx,xxx
117, 202, xxx,xxx
I want to clearly separate for example projectNo 111 from 113 (with a line or whatever), ie group the records by projectNo. This can be done in reports, but can it be done in forms?
Im ok with anything that separates the projects from each other (borders/colors etc).
Thanks!
I've got a project database which I want to be able to present in a nice way.
In one table I've got the fields:
project no
resourceNo (person working in the project)
documentA-progress
ducumentB-progress
documentC-progress
etc..
Each project may have many persons working in it with different documents. There may in other words be several records with the same projectNo but different resourceNo.
In my report I've grouped all records working with the same projectNo together with the grouping tool (several records of different resourceNo in each). It is thus easier to separate the different projects.
My problem is that reports (as far as I know) don't allow freezing of the header when scrolling down (like in Excel). I'm told to work with forms instead.
But are there any functionality for grouping records together in forms? I don't understand how to do this.
To clarify, my data look like this:
projectNo, ResourceNo, documentA, documentB..
111, 201, xxx,xxx
111, 203, xxx,xxx
113, 201, xxx,xxx
113, 202, xxx,xxx
113, 203, xxx,xxx
117, 202, xxx,xxx
I want to clearly separate for example projectNo 111 from 113 (with a line or whatever), ie group the records by projectNo. This can be done in reports, but can it be done in forms?
Im ok with anything that separates the projects from each other (borders/colors etc).
Thanks!
