I assume that you are storing this data in a database.
You could create a table that contained Unique Number and one Vx value.
Your main table would have Unique Number, Unique ID String, etc. but
not the Vx values.
When you want the Vx values for a given record you just do a join to
pull out the ones with the matching Unique Number.
Cheers,
Malcolm
On Aug 30, 2007, at 1:15 PM, Dave Shirk wrote:
> Hello All,
>
> I have a very strange set of data I need to access, and I can
> not formulate a "good" way of accessing it.
>
> The data set looks like:
>
> Unique Number, Unique ID String, Unique Name, Classifier1,
> Classifier2, Classifier3, V1, V2, ....., Vn
>
> Where:
>
> Vx are other possible ID Strings that relate back to the same Data
> Info.
> There may be 0 V entries, or as many as 60. All V ID's are also
> unique.
>
> So ... I have a Many to one relationship.
>
> Any suggestion on a way to set this up for fast access?
>
> I have a feeling my brain is simply fogged at the moment, and there
> must be an "obvious" solution.
>
> Thanks in advance,
>
> Dave Shirk
> Oriental, NC
>
>
> _______________________________________________
> Unsubscribe or switch delivery mode:
> <http://www.realsoftware.com/support/listmanager/>
>
> Search the archives:
> <http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|