>>>Wow, you mean I WASN'T the only ARev developer in thw world?
>>>
>>>You are absolutely right, I haven't used ANYTHING since that comes close to the power of Arev. The multivalue field alone is worth 10 of any other product. Other than the app I worked on, plus some I did for my own personal use, the only other time I've seen ARev in the field is an application for collection agencies. Unfortunately, somewhere along the line I lost my copy of the program (maybe when I switched to a computer with no more 5 1/4" floppy drive...), and just last week while cleaning up in the basement I tossed my copy of the User's Guide. Finding that in a box of other stuff inspired me to check out the web site - amazing to find the company still in business. I too totally lost touch when Open Insight appeared, by that time I was working on some heavy FoxPlus/Mac and Foxpro 1.x stuff.
>>>
>>> Randy
>>
>>Randy,
>>
>>AAAAAAHHHHHH!!!! I hate that multivalue field! I thought I heard the last of it when I switched jobs! Now you bring it back!?!
>>
>>I somewhat worked with the Unidata database and our software vendor utilized multivalue fields. I had a terrible time using ODBC to get the data I needed.
>>
>>I need to go back to counseling now. Thanks.
>>
>>LOL
>>
>>Dan
>
>Ouch! That hurts! :-)
>I *LOVED* the AMV.
>Why were you using the ODBC connections? Accessing remotely?
>JLK

Jerry,

I was reading tables using Access at the time. If they stored an address in a MV field (address, city, state, zip) you could not SELECT for just zip = 50315 for instance. It would also return one record for each "subvalue". Made the amount of data moving over a wire considerably larger. This was about six or seven years ago. I'm sure they have improved the ODBC support since then. But I'm not even going to think about it :)

Dan