HI I have a access Table that has some information for Category1 and Category2 I wan to link this one table to Two different SharePoint site where on one site List it will display only Data where Category = Category1 and Second SharePoint site it will display data from this table where Category = Category2, is it possible to achieve? I am using Access 2007 and MOSS

Hi, As list does not supports join, I don't think this is possible OOB. There is custom solution which you can try. Link the data from Access 2007 to custom list. Have a event handler on the custom list to insert the data into 2 more lists. Thanks, Skancharla

Hi, Does the two lists in the same site collection? If yes, you may consider using the workaround below: Assume that Table A is your original Access data table 1. Export Table A to SharePoint site and rename it Table1 2. Link Table 1 back to Access to ensure that the data between Access and SharePoint can sync with each other. Now when you change the data in SharePoint list or access, the data will be updated to each other. 3. Modify the view in SharePoint list: Table 1 to filter the data when column “Category” is equal to 1. Now the list “Table 1” will only display the items in which the column “category” is 1. 4. Add the webpart in another SharePoint site under the same site collection and choose “Table 1”. Rename it to Table 2 and use the same method to modify the view to filter the list by “category”. This time the filter is display the items in which “category” is equal to 2. For detailed steps about export and link access database to SharePoint list, please refer to this article: http://www.vb123.com.au/toolbox/09_access/accessAndSharepoint.htm Hope this helps. Lu Zou

DO you have any code sample for Event Handler to write data in to another list?

Hi Skancharla, Thanks for this note, I still have to learn how to do Custom programming in .NET for SharePoint. I know how to use Desinger and pretty much I work around there. But your idea sounds good.

No not in Same Site collection.

Hi, Here are some reference links on using Event Receivers, http://www.davehunter.co.uk/Blog/Lists/Posts/Post.aspx?ID=69 http://msdn.microsoft.com/en-us/library/ms453149.aspx http://www.wrox.com/WileyCDA/Section/Programming-Event-Handling-in-Windows-SharePoint-Services.id-306329.html http://www.sharepointkings.com/2008/06/redirection-from-event-handler.html http://farhanfaiz.wordpress.com/2007/12/31/creating-adding-an-event-handler/ Thanks, Skancharla