do you mean, "set up a database that is used to store lists" ?
Originally Posted by amateur99
each list has a title. When a title of a list appears in another list I want that to be detected somehow.
What is the structure of the lists you are considering? I've entered an example below; are you considering something similar?
List Title A
1: this is list item 1 for List Title A
2: This is list item 2 for List Title A
N: This is list item N for List Title A
List Title B
1: this is list item 1 for List Title B
2: This is list item 2 for List Title B
N: This is list item N for List Title B
If this is the structure for your lists, create two tables; one for titles (serial title_id field, and varchar title), and one for items (int title_id, int display_sequence and varchar list_item.) Add foreign key constraints on the items.title_id, to titles.title_id.
Finally, do you want to disallow duplicate list titles? i.e. Do you want the titles to be unique? Or, do you just want to be notified if there is a duplicate title? If you want unique titles, just add a unique constraint on the title field.
The database server isn't going to notify you that a duplicate title already exists, but your front end application could.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert