Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Advice on Database/table structure

Status
Not open for further replies.

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.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top