Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread S�ndor Hal�sz
2011/03/01 20:23 +0800, Wagyu Beef Part of the database consists of two tables "events" and "categories" which look like this +---+-+ | eventID | eventName | +---+-+ | 1 |

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread Wagyu Beef
Oh yeah, forgot to mention that. Yes, one event will have multiple categories. And one category can be applicable to multiple events. On Tue, Mar 1, 2011 at 8:33 PM, Dhaval Jaiswal < jaiswal.dha...@enzenglobal.com> wrote: > > Just curious as it is not mentioned. Can Category ID also have multi

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread Dhaval Jaiswal
Just curious as it is not mentioned. Can Category ID also have multiple event id ? -- Cheers Dhaval Jaiswal On 01/03/2011 5:53 PM, Wagyu Beef wrote: Hey guys, Am a newbie here and need a little help. Part of the database consists of two tables "events" and "categories" which look like th