> From: gvim
>
> 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
>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 k
On Thu, Dec 9, 2010 at 3:33 PM, gvim wrote:
> 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
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 nu
