Recent content by psh

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...

try using WinIP, a free utility found at: http://www.dragonmount.net/software/winip/