Guys Please Help
You need a third table that you can link to diary can contacts so that you can have one record for each appointment. A portal from diary to appointments can be used for recoring/editing appointments for the day. Then you can produce your report from the appointments table instead of using multiple fields in the same record.
Thanks for reply. Just a quick verification, without adding any table in middle cant i write script to find the contact id in those 20 fields. for instance lets say i write to find to script to find in field01, field 02, field03, field 04, untill to filed 20 ?
The reason why i asked that (this diary is already connected to web uysing CWP now it all done , i am afraid to modify this again and that will make me to develop web part again....:))
Such a script would be pretty complex to write. You'd have to loop through the fields and then loop through the records counting instances of a given contact. If you need this for multiple contacts, you'll need to do this multiple times--a real mess to work with.