mikevds@optonline.net
Access Tables
Table: Name of Hymnal
Fields
Hymnal ID
Name of Hymnal
Table
Hymnal Song Info.
Fields
Id Hymnal
Name of Song
Hymnal Song
Hymnal Number
Hymnal Name
Composer Name
Arranger Name
Arranger Number
Author Number
Author and Key
Scripture
Key
Tune
Meter
Media Type
The Purpose is I want to have 2 populated list boxes
The other one from Hymnal Song Info. Table, Name of Song Field
One from Name of Hymnal Table, Name of Hymnal Field
Populated Box 1- click on Name of Song
Populated Box 2 click on Name of Hymnal, only displays hymnals from that song.
I tried using the SQL Coding, but it’s not populating, then it messes up my other forms for Audio CD’s that display is cdauthor name and cdname.
Here is the SQL Coding, I’ve used but I am having trouble, I am willing to email the database so you can see my problem. Otherwise it would be very time consuming.
HymnalSongInfooneQuery
SELECT HymnalSonginfo.[ID Hymnal], HymnalSonginfo.[Hymnal Name], HymnalSonginfo.[Name of Song], HymnalSonginfo.[Hymnal Song Number], HymnalSonginfo.[Hymnal Number], HymnalSonginfo.[Composer Name], HymnalSonginfo.[Composer Number], HymnalSonginfo.[Arranger Name], HymnalSonginfo.[Arranger Number], HymnalSonginfo.[Author Number], HymnalSonginfo.[Author and Key], HymnalSonginfo.Scripture, HymnalSonginfo.Key, HymnalSonginfo.Tune, HymnalSonginfo.Meter, HymnalSonginfo.[media Type], [Name of Hymnal].[Hymnal Number ID], [Name of Hymnal].[Name of Hymnal]
FROM HymnalSonginfo LEFT JOIN [Name of Hymnal] ON HymnalSonginfo.[ID Hymnal] = [Name of Hymnal].[Name of Hymnal];
can u email me the sql coding
Access Tables
Table: Name of Hymnal
Fields
Hymnal ID
Name of Hymnal
Table
Hymnal Song Info.
Fields
Id Hymnal
Name of Song
Hymnal Song
Hymnal Number
Hymnal Name
Composer Name
Arranger Name
Arranger Number
Author Number
Author and Key
Scripture
Key
Tune
Meter
Media Type
The Purpose is I want to have 2 populated list boxes
The other one from Hymnal Song Info. Table, Name of Song Field
One from Name of Hymnal Table, Name of Hymnal Field
Populated Box 1- click on Name of Song
Populated Box 2 click on Name of Hymnal, only displays hymnals from that song.
I tried using the SQL Coding, but it’s not populating, then it messes up my other forms for Audio CD’s that display is cdauthor name and cdname.
Here is the SQL Coding, I’ve used but I am having trouble, I am willing to email the database so you can see my problem. Otherwise it would be very time consuming.
HymnalSongInfooneQuery
SELECT HymnalSonginfo.[ID Hymnal], HymnalSonginfo.[Hymnal Name], HymnalSonginfo.[Name of Song], HymnalSonginfo.[Hymnal Song Number], HymnalSonginfo.[Hymnal Number], HymnalSonginfo.[Composer Name], HymnalSonginfo.[Composer Number], HymnalSonginfo.[Arranger Name], HymnalSonginfo.[Arranger Number], HymnalSonginfo.[Author Number], HymnalSonginfo.[Author and Key], HymnalSonginfo.Scripture, HymnalSonginfo.Key, HymnalSonginfo.Tune, HymnalSonginfo.Meter, HymnalSonginfo.[media Type], [Name of Hymnal].[Hymnal Number ID], [Name of Hymnal].[Name of Hymnal]
FROM HymnalSonginfo LEFT JOIN [Name of Hymnal] ON HymnalSonginfo.[ID Hymnal] = [Name of Hymnal].[Name of Hymnal];
can u email me the sql coding