Susan Owen
Registered User.
- Local time
- Today, 20:00
- Joined
- Jul 8, 2002
- Messages
- 33
Pat Hartman said:SharePoint tables are something like:
UniqueRowID (a unique identifier for the row)
GroupID (what would in a normal table be the primary key)
FieldName (the name of the field)
FieldValue (the value of the field)
So, instead of a table having 20 columns per row, each column would be stored as a separate row in the SharePoint table.
Thanks, Pat. That's exactly how this works, if I have understood your description correctly (which was much clearer than my attempted description of this database design.)
The specific field names are stored as field values, that's the essence of it. The actual field names are generic, so that the same structure / design can store anything.