good day, I'm having a little problem in subforms and report. Here's what i want to do; i want to create a list of equipments listed in a certain room and will generate a good report. but, when i create a subform in the buttom of my "title" and add a new list of equipments in a different room. it always warns me that it would create a duplicate. it's a good thing that it warns me about a duplication in my first input. but, how about if i add a new room? what if i want to input a same equipment in that room? how can i eliminate the warning sign?
also in my report. Why is it that when i input a series of equipments in that room and view it in the report, it would create a multiple Description of that equipment?
i hope i explian it clear and any help would be much appreciated.
Also i attached a sample access here, i hope you can help me.
thank you
archie