Relational purist that I am, I would use a many-side table with a row for each job function for an employee. Indexes would retrieve everybody with a particular job function quickly. And a "SELECT List of (colname)" would get you your comma-separated list if and when you need it.
(sent from Moto Z) On Dec 21, 2016 8:12 PM, "jan johansen" <[email protected]> wrote: Group, Having a sugar induced brain cramp. I want to store a comma separated list in a table. Basically want to save either a list of job functions by individual or assign individuals to job functions. So a person can have more than one job function or job functions can have several people. I don't seem to see a DB object that allows multi-select. Am I blind? Jan Please note that JJ Calibrations will be closed on Friday the 23rd and Monday the 26th so that our employees can be with their families. We will also be closed on Monday, January 2nd. We will respond to emails as quickly as we can upon our return. Thank you, Eric Johansen President -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
