houstonbill
Technical User
- Nov 6, 2006
- 92
Looking for advice on table set up to get end result form/report I am looking for. My mind is just blank. What I have is working but does not allow for report headers, making the report pretty ugly.
Have a Main form that pulls the following from tblSuggest
SuggID
Idea
Current
SuggAction
Have #1 subform attached to pull memo field entries from tblRev:
SuggID
Communication
Competitive
Costs
CustProv
EmpSat
Feasibiliy
Novelty
Safety
StrategicPlans
Have #2 Crosstab subform with the following fields that will have a number of 1-5 assigned to them by the user (again from tblRev)
SuggID
CommNum
CompNum
CosNum
CPnum
ESnum
FeasNum
NovNum
SafeNum
SPnum
With the report I would like to be able to catergorize each main item name with all comments attached to it for each suggID. Currently they are in detail area of the report and the titles continue to repeat for each users entry. I also have all items in each category on the form with a drop down for numbers 1-5 (subreport#2) with memo fields following after all items ranked (Subform#1). I have tried separating out in differnt tables but as I mentioned, my mind is blank and can't seem to find the right combo. Any ideas would be appreciated.
Have a Main form that pulls the following from tblSuggest
SuggID
Idea
Current
SuggAction
Have #1 subform attached to pull memo field entries from tblRev:
SuggID
Communication
Competitive
Costs
CustProv
EmpSat
Feasibiliy
Novelty
Safety
StrategicPlans
Have #2 Crosstab subform with the following fields that will have a number of 1-5 assigned to them by the user (again from tblRev)
SuggID
CommNum
CompNum
CosNum
CPnum
ESnum
FeasNum
NovNum
SafeNum
SPnum
With the report I would like to be able to catergorize each main item name with all comments attached to it for each suggID. Currently they are in detail area of the report and the titles continue to repeat for each users entry. I also have all items in each category on the form with a drop down for numbers 1-5 (subreport#2) with memo fields following after all items ranked (Subform#1). I have tried separating out in differnt tables but as I mentioned, my mind is blank and can't seem to find the right combo. Any ideas would be appreciated.