Comparing Two Combo Boxes [message #201713] |
Mon, 06 November 2006 08:20 |
qadeerahmed
Messages: 63 Registered: July 2006 Location: Pakistan
|
Member |
|
|
Hi,
I want to compare two combo boxes, is it possible? if Yes then HOW?
What Queries Will be Used to accomplish this task.
Thanks
Regards
Qadeer Ahmed
|
|
|
|
|
|
Re: Comparing Two Combo Boxes [message #203275 is a reply to message #201713] |
Tue, 14 November 2006 09:56 |
yogen
Messages: 39 Registered: October 2006 Location: UK
|
Member |
|
|
You need make clear yourself about your query first.Do you want to number of item in 2 diffrent combo boxes? or first item in 1 combo box with 1st item in another combo box and so on...?
or do you mean something else by this comparison.
Try to put your requirement with some example then only you may get good answers..
|
|
|
|
|
|
|
Re: Comparing Two Combo Boxes [message #203952 is a reply to message #203684] |
Fri, 17 November 2006 01:15 |
qadeerahmed
Messages: 63 Registered: July 2006 Location: Pakistan
|
Member |
|
|
Hi,
I would like you to clear one thing that is not clear to me.
Would it be better to take the 'Intersection' Rather using the 'Get_Group_Char_Cell'.
Because I only want to see is either both the combo boxes have atleast one element common.
What would you suggest.
Regards,
Qadeer Ahmed
|
|
|
|
Re: Comparing Two Combo Boxes [message #204022 is a reply to message #203958] |
Fri, 17 November 2006 06:23 |
qadeerahmed
Messages: 63 Registered: July 2006 Location: Pakistan
|
Member |
|
|
HI & Thanks !!
Yes I'm looking for that has the same contents not the same number of elements.
Ok! I'll try to Explain you, Hopefully you'll get my point.
Consider an example of course Registration at the university level. University offer some courses for each semester from semester 1 to 8.
Students enroll some courses, against it there rollno is saved; specifying the student had register that course.
Student may be of any semester 1 to 8 and can take course with any semester.
e.g due to any reason he was not able to pass that course, so he has to take that course with the juniors. So the Students of Semester 6th can take course with the students of Semester 3rd;
So While making the date sheet for the exams, We have to keep in mind that there will no Clashes occur. Clashes Means, If One Student has an exam of two courses on the same day.
This can happen because as i wrote earlier that students can take courses with the junior semester students. And We are making separate Datesheet for each and every semester.
Hope so you got it all right !!!
Now,I've an LOV for the courses of 1st Semester. I select any of it. Now i Move on towards the Datesheet for 2nd semester for that i also have an LOV of the courses for 2nd semester. I select any course from there.
What If any Senior Student Was Taking Course With the Semester1 Student also, And Unfortunatly the subject we selected From LOV's of semester 1 and semester 2 were both registered by the Student. So we have a clash.
So How can I check that the Clash exist? And It displays msg that Clash Exists Choose Other Subject.
Thanks !!!
Regards
Qadeer ahmed
|
|
|
|
|