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] [mailto:[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] [mailto:[email protected]]. For more options, visit https://groups.google.com/d/optout [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] [mailto:[email protected]]. For more options, visit https://groups.google.com/d/optout [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.

Reply via email to