On Mon, Aug 29, 2011 at 10:28 AM, Fred Taylor <[email protected]> wrote: > You could maybe use a multi-select list and binary OR the values together > and store as a single value. > 1=Hot > 2=Phoenix > 4=BPOE > 8=other > etc. > store the value as a 7 ---------------
Either have a bitwise value to parse out which was true/false in your list. Or make a collections/linker table to reference by row that CustID 123 has a link with CustomerType 456, 56998,47551, etc. Bitwise demands that you tweak the front end to match data contained. -- Stephen Russell Unified Health Services 60 Germantown Court Suite 220 Cordova, TN 38018 Telephone: 888.510.2667 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYL7SM5kvpiBbGjuV+tHYfRdomD9VFNcBoUkD_jKpe-==a...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
