I got auto-corrected. Should have been LISTOF(colname) .
(sent from Moto Z) On Dec 21, 2016 8:29 PM, "jan johansen" <[email protected]> wrote: > Bill, > > Good point. > Let me explore one to many form. > > Jan > > > -----Original Message----- > From: Bill Downall <[email protected]> > To: [email protected] > Date: Wed, 21 Dec 2016 20:25:01 -0500 > Subject: Re: [RBASE-L] - Store comma seperated > > 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. > > > 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.
