>From: gvim [mailto:gvimrc@stripped]
>Sent: Thursday, December 09, 2010 9:33 AM
>Subject: Design: how to prioritise 1-to-many fields
>I have a typical contact database which caters for multiple email addresses
>with a distinct Email table keyed to a foreign key inside the Contact table,
>ie. a 1-to-many relationship. However, I want to prioritise these Email
>for a given Contact entry so all I can think of is to add a numeric Priority
>field alongside the Address field inside the Email table. Is this the
>best/standard solution or is there another way?
[JS] Sounds about right to me, but don't use a sequence like 1, 2, 3. Use 10,
20, 30. You never know when you'll have to squeeze in a new priority level,
and you don't want to have to renumber them all.
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe: http://lists.mysql.com/mysql?unsub=1