My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() Post#1 | |
Posts: 1 Joined: 31-January 05 From: Columbus, GA ![]() | Hey guys; I'm not very well-versed in Access and I am currently administering a WSS site. I have a couple of questions on the SharePoint side: Is there a way to prevent duplicate entries from being created in a specific SharePoint column of a list and from duplicate entries in a list? From what I understand, this would be the same as a keyed access table (I'm not very clear on that). Basically, what we want to do: If we have a list of employees in which we already have an ID number in another application, load that data into SharePoint and then prevent someone from entering another employee (into SharePoint) with the same ID number. Or at least warn the user that the value already exist. That only references one specific column. If that is possible, is it possible for SharePoint to cross-reference across multiple columns when creating a new entry? IE: If X-user is scheduled to work on Z-date with Y-vehicle, if someone attempted to schedule W-user on the same Z-date with the same Y-vehicle - it would throw up an error. We do have Access 2003 so we can work with lists in that manner if needed. Thanks for any help! -Joseph- -------------------------------- Joseph Brannan, CBNT IT Admin Clear Channel Radio Columbus, GA |
![]() Post#2 | |
UtterAccess VIP Posts: 1,644 Joined: 24-May 02 From: Sweden ![]() | It cannot be done with the standard functionality within WSS. Everything in Sharepoint is stored in a SQL Server (or MSDE) database but it's not that simple as adding validation rules or constraints in the database as you would do in Access.
You should NOT try to change anything directly in Sharepoints SQL Server database. It might irreversibly corrupt your whole Sharepoint installation. All configuration must be done through the web interface in Sharepoint. To solve your issue it takes advanced programming skills and knowledge about .NET, web parts and web services. I don't know of any simple way to do something like this. You might want to take a look at MsD2D to see if anybody else have tried something similar __________ Bo Melin Edited by: bome on Wed Feb 2 10:16:37 EST 2005. |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 15th December 2019 - 11:31 PM |