Re: Multiple Entries

2006-06-26 Thread Chris White
On Monday 26 June 2006 08:03 am, Nicholas Vettese wrote: > If I have a multiple choice on a form and want to store that in my DB, then > how should I set up my table? I have been reading up on these, but > everyone seems to have a different opinion on how to accomplish this task. > What I am look

Re: Multiple Entries

2006-06-26 Thread JamesDR
Nicholas Vettese wrote: If I have a multiple choice on a form and want to store that in my DB, then how should I set up my table? I have been reading up on these, but everyone seems to have a different opinion on how to accomplish this task. What I am looking to do give the user a few options to

Multiple Entries

2006-06-26 Thread Nicholas Vettese
If I have a multiple choice on a form and want to store that in my DB, then how should I set up my table? I have been reading up on these, but everyone seems to have a different opinion on how to accomplish this task. What I am looking to do give the user a few options to check when submitting

RE: Can one SELECT records depending on multiple entries in a many to many table?

2001-10-02 Thread Joe Kaiping
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin > Hi. > > On Mon, Oct 01, 2001 at 07:54:37PM -0700, [EMAIL PROTECTED] wrote: > > > > Hi there, > > > > I have a many-to-many relationship: > > > > ind table > > - > > id = 4, name = Joe

Re: Can one SELECT records depending on multiple entries in a many to many table?

2001-10-01 Thread Benjamin Pflugmann
Hi. On Mon, Oct 01, 2001 at 07:54:37PM -0700, [EMAIL PROTECTED] wrote: > > Hi there, > > I have a many-to-many relationship: > > ind table > - > id = 4, name = Joe > id = 5, name = Jane > > bus_ctr table > - > id = 1, name = downtown mall > id = 2, name = sunshine mall > i

Can one SELECT records depending on multiple entries in a many to many table?

2001-10-01 Thread Joe Kaiping
Hi there, I have a many-to-many relationship: ind table - id = 4, name = Joe id = 5, name = Jane bus_ctr table - id = 1, name = downtown mall id = 2, name = sunshine mall id = 3, name = express shop mm_ind_bus_ctr table (many to many association table)