Normalization Denormalization of tables. Keep it denormalized when it is possible.

[Mile-O]

Regarding the calls with fourteen different responses - here's a quick mock up of a better way to tackle it.

 

[KenHigg]

Off topic:

Mile - Who is the attractive young lady you have as an avatar?

ken

 

[Mike375]

Off topic:

Mile - Who is the attractive young lady you have as an avatar?

ken

Ken,

What is an avatar?

Mike

 

[KenHigg]

Hi Mike,

It's the little picture some people put by thier user name.

How's you day going?

ken

 

[Mile-O]

Mile - Who is the attractive young lady you have as an avatar?

Audrey Tatou.

 

[Mike375]

Regarding the calls with fourteen different responses - here's a quick mock up of a better way to tackle it.

Mile-O-Phile

I think that is what we have in the second table that records each call?? If we ring someone 100 times then 100 records are created in the Many table for that person. Is that similar to what you are illustrating.

The call results being entered on the persons record in the main table are to determine when their record displays, when it should be moved to another table and a replacement record brought in etc.and etc.

Mike

 

[Mike375]

Audrey Tatou.

Who or what is Audrey Tatou.

Is that Mile-O-Phile.

Mike

 

[Mike375]

Hi Mike,

It's the little picture some people put by thier user name.

How's you day going?

ken

Ken,

Actually, I had an extremely good day, about to finish now with an early night. 11.35pm here.

Is "avatar" a word that is the product of bulletin boards?

Mike

 

[KenHigg]

Never seen the word much before, outside computers, but message boards, etc seem to be where the term is used most (I think).

Catch you tomorrow... Only 9am here...

ken

 

[Mile-O]

Audrey Tatou is a French actress from such films as Amelie and Dirty Pretty Things.