Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Multi-Table Form

  Asked By: Jim    Date: Jan 15    Category: Sharepoint    Views: 1287

I am stumped. I have an existing application that has a form. The form
data is saved to 4 different tables through the business object. It is a very
simple star schema with one table maintaining the key and the other 3 storing
the FK. On subsequent calls, the biz obj is loaded based on this data. So....
i'm in the process of moving this application into SharePoint, and here is where
I am ...do I create one form with all of the fields (from the different tables)
on one form ? or do I try and create a one parent list, with 3 child tables in
SharePoint that maintain those parts of the data? Just not sure what to do.



1 Answer Found

Answer #1    Answered By: Kala Solomon     Answered On: Jan 15

Just because you are migrating an application  to sharepoint  does not mean the
data should be stored in SharePoint. SharePoint lists are not a relational
database. I would suggest leaving the data  in a relational database and
creating 4 custom web parts  (or maybe use the dataform web part if you aren't a
developer) . Add the webparts to a page and set it up so the one webpart is
connected to the other three and passes the key  as a filter.

Didn't find what you were looking for? Find more on Multi-Table Form Or get search suggestion and latest updates.