Thanks Rick.
The technique you suggested works, but is a little cumbersome. At this time it is the better option I have and I have decided to go with it.
Thanks again.
Jim,
Thanks for taking the time to reply my question. So far, I have been getting my repors the way you have described above. I want to eliminate the repetition in drawback, also.
Simply putI want the report to look like how a lay folk would write in a spreadsheet, say - Column1 models name...
Thanks for the reply Larry.
I tried it. It works, but only partly. Upon three level of grouping - model, capability and drawback, I still get the drawbacks repeated for every one of the capability. Ofcourse, the repetition in Model and Capability is no longer there.
I wonder if there is some...
Thanks for the reply. I knew I could count on you folks out there.
I have a follow up question. I would like to be able to do what you have suggested in a report, rather than a form. How do I do it in a report, and can you please walk me through? Thanks ahead.
psh
Problem: A model has 'n' drawbacks and 'm' capabilities. There are three tables(models, capabilities and drawbacks).
Table description:
models (model_id(pk), model_name)
capabilities ([model_id, cap_id](pk),capability)
drawbacks ([model_id, draw_id](pk),drawback)
Relationship:
model-id of...
Problem: A model has 'n' drawbacks and 'm' capabilities. There are three tables(models, capabilities and drawbacks).
Table description:
models (model_id(pk), model_name)
capabilities ([model_id, cap_id](pk),capability)
drawbacks ([model_id, draw_id](pk),drawback)
Relationship:
model-id of...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.