>From: gvim [mailto:gvi...@gmail.com] >Sent: Thursday, December 09, 2010 9:33 AM >To: MySQL >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 >entries >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.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >gvim > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/mysql?unsub=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org