QUERY EMPTY FIELD AND ADD DATA

[Guest]

I need to query a table with three columns, Authors, Songs and location;
In the Author Field, it has many Author names and with 1.. many empty data
or null in the authors field [authors] with many records for the field
[songs] and [locations].
Need to know how to creat two relational tables, one authors and one songs
with my data. Can some one show me how ?
Email me at (e-mail address removed)
Thank U...
example of table;
Author Songs Locations
Author Songs Locations
Nat 'King' Cole
null Love 62-06
null Ramblin' Rose 127-06
null This Is All I Ask 41-09
null Unforgettable 300-09
Shenandoah & Alison Krauss
null Somewhere In The Vicinity Of The Heart 288-09
Costello & Bacharach
null She 22-10
Shaggy & Brian & Tony Gold
null Hey Sexy Lady 166-08
Sonny & Cher
null I Got You babe 123-10
null I Got You Babe 297-03
null I Got You Babe 152-03
null The Beat Goes On 14-08
null The Beat Goes On 291-15

 

[Tim Ferguson]

Need to know how to creat two relational tables, one authors and one
songs with my data. Can some one show me how ?

Sorry: you need (at least) three tables for this classic many-to-many
relationship...

Singers (SingerID, FullName, HomeLanguage, Range, etc)

123, Nat King Cole, Eng, Baritone
125, Alison Krauss, Eng, Alto
129, Shenandoah, Sioux, Soprano

Songs(SongNumber, EnglishTitle, OriginalLanguage, NumberOfVerses, etc)

1018, Love, 62-06
1043, Ramblin' Rose, 127-06
1066, Somewhere in the vicinity of the heart, 288-09

SingingOn(SingerID, SongNumber, RubbishOrNot, etc)
123, 1018, Fantastic
123, 1043, Okay I suppose if you like slushy ballads
125, 1066, Fantastic
1066, 129, Rubbish


and so on. Hope that makes sense.


Tim Ferguson