> From: gvim <gvi...@gmail.com> > > 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?
Ask yourself, "what has a relationship with what." Do these Email table entries have relationships with each other? Perhaps a better way would be for Email table entries to be threaded together in a linked list: "Primary --> Secondary --> Tertiary --> ..." rather than put an arbitrary number in there. ---------------- I hope we shall crush in its birth the aristocracy of our moneyed corporations which dare already to challenge our government to a trial of strength. -- Thomas Jefferson :::: Jan Steinman, EcoReality Co-op :::: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org