Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Create a simple Relational Database using lists

  Asked By: Robin    Date: Sep 24    Category: Sharepoint    Views: 3115

Can someone point me to an example of how to implement the following
type of application inside WSS 2003?

I would like to be able to link tasks to requirements. The catch is
that that a task could be linked from 0 to N requirements.

For example, here are three tasks and three requirements.

Task 1. Design a webpage layout for home page.
Task 2. Chose a database for website backend.
Task 3. Chose a Hardware to host the web front end.

Req 1. Design for 1000 concurrent users.
Req 2. Average page load under 1 sec.
Req 3. Provide full text search.
Req 4. Navigation should be on top of page.

In this example,
Task 1 is subject to requirements 1-4
Task 2 is subject to requirements 1-3
Task 3 is subject to requirements 1-3

I really have two questions.

1- how to link the lists (assuming that is the right approach)
2- Best way to create a GUI



1 Answer Found

Answer #1    Answered By: Christop Mcfadden     Answered On: Sep 24

And there you’ve hit on a huge request in the world of SharePoint: relational  lists. The short answer: SharePoint provides no support OOTB for linking lists  and making them relational (both in wss  v2 or v3). This doesn’t mean you couldn’t implement  it yourself through the GUI… it’s just not a trivial undertaking.

Didn't find what you were looking for? Find more on Create a simple Relational Database using lists Or get search suggestion and latest updates.