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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to avoid repetition?
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...- psh
- Thread
- Replies: 6
- Forum: Microsoft: Access Other topics
-
Avoid repetition in report
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...- psh
- Thread
- Replies: 3
- Forum: Microsoft: Access Reports
