Hello everyone, I have some problems I need to face while creating a certain list in sharepoint 2007 (must be in 2007 and cannot be in 2010), for an organization i work in. It uses only sharepoint and all office products so infopath is included. new applications can't be installed.
1. I need that data in two different drop-down list boxes will be dependent. What I mean is that if for example the first drop-down list box offers me the options: deserts, drinks, main meal, then if one chooses deserts, the next drop-down list box will offer: chocklate cake, apple pie, and so on.
2. I need that some of the columns of a sharepoint list will not be presented for the user when creating a new item.
3. I need to create premissions for certain groups. For example, creating a group of empoyees and a group of managers, and the employees could edit only a certain columns, and others they won't have premissions (and same for managers)
4. I need that during the creation of a new item, a checkbox will be presented, and if the user has checked it, then a message box will appear at the end of the creation of the new item. It is used to remind the user something he always forgets...
I have more questions but these are the most important ones. Someone I have asked told me the mentioned problems can be resolved using InfoPath, and that it could be incorporated with sharepoint so that user will only see that sharepoint list (and not even know about infopath). However, though I tried many times to understand how, I am still stuck.
Help will be appreciated, thanks in advance, Itay