|
-
Apr 20th, 2003, 08:56 PM
#1
Thread Starter
Fanatic Member
How would you represent this data in a dataset?
I'm working with some data that I'm having some trouble finding a good structure for. The data is something like this:
SomeName(String, key); SomeCategory(String); VaryingSubfield(see below)
VaryingSubfield can contain zero or more record-like data entities (record-like in themselves) of the rough format:
SomeString2(String); SomeString2(String); .... SomeString8(String)
The values for this "record" are not required to be unique.
I have considered making VaryingSubfield a relation pointing to a separate table, but I'm not sure how to represent VaryingSubfield if it contains more than one item without some really hackish stuff (e.g. an array with the contents being row IDs to the child table). I'm fairly comfortable with non-relationable tables but haven't spent a lot of time with relational tables.
This may be really easy, I dunno, but I have been scratching my head over this for a while now.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|