Hi everyone. I am having an issue that I would appreciate some help with. I created a Composers table that I thought would be useful to when populating my song database where there are separate fields for LyricsBy and MusicBy. Normally, these fields are going to be identical, but not always. The relationships from TABLE - MasterSongIndex to TABLE - Composers were created automatically by Access when I set up the LyricsBy and MusicBy fields to look up the values in the Composers Table. I did not expect a table to be "sub-created" or whatever as TABLE - Composers_1, but my issue is that it appears whenever the LyricsBy and MusicBy values are not entered as identical names, when I click on the Composers Table and click the + sign on the composer's name, the songs do not show up if there is a difference in the two fields. Do I need to create separate tables for LyricsBy, MusicBy and for all composers? Thanks for any input or suggestions and Happy Thanksgiving to those of you in the United States. ---Jerry Boor, Rochester Hills, Michigan
Posted by: Jerry <bearjercares@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar