It's called a many-to-many relationship and you use a cross-reference table
to represent the relationship. Say you have table
Searches
-
SearchID
FromDate
ToDate
etc...
Users
UserID
FirstName
LastName
Then to define what users are associated with what searches, you creat
Replying to my question, to add a bit of information specific to my
current situation. Please see below --
On 2/13/08, P Kishor <[EMAIL PROTECTED]> wrote:
> On 2/13/08, gongchengshi <[EMAIL PROTECTED]> wrote:
> >
> > I have a table were each row needs to be able to store a list of entries
> > fro
On 2/13/08, gongchengshi <[EMAIL PROTECTED]> wrote:
>
> I have a table were each row needs to be able to store a list of entries from
> another table as one of its attributes. For instance the table is a
> collection of search filters. The filters table has attributes: FromDate,
> ToDate, Users,
At 5:00 PM -0800 2/13/08, gongchengshi wrote:
>I have a table were each row needs to be able to store a list of entries from
>another table as one of its attributes. For instance the table is a
>collection of search filters. The filters table has attributes: FromDate,
>ToDate, Users, Devices. Th
I have a table were each row needs to be able to store a list of entries from
another table as one of its attributes. For instance the table is a
collection of search filters. The filters table has attributes: FromDate,
ToDate, Users, Devices. The Users attribute is not a single value but a
lis
5 matches
Mail list logo