Extend Found Set
Ok I know this isnt the best way to have built a database but this is how I did it so I was just wondering if someone can give me a pointer on how to create a script. Heres the situation I have 10 tabs each with seperate contacts for the same company. It shows the company in the top then it has a tabbed box that has contact 1 for tab 1 contact 2 for tab 2 etc. It also has follow up date fields. These fields are for the callers to enter when to call the person again next. For example Tab 1 has Follow1 on it then tab 2 has Follow2 on it and so on. What I am trying to do is create a button that when clicked searches all the tabs Follow1, follow2, follow3 ect. at the same time for the current date. Then put them in a layout or something that shows who the caller will be following up with today. Would this be done using extend found set? If so how do you use this command because I dont understand how it really works. Thanks for the help!