My database (the only Access db I have) is one of managing my large record collection.
I have a form in which I enter a song title in the box at the top and Access returns the first record matching that title or substring.
I would like it to bring up a page of choices for those songs for which there are multiple songs with the same title. In the songs table, these songs
have their own dummy record with only the song title (in the field "title") and the number 999 in the field "code1".
For each title with code1= 999, there is a matching entry in a table called "dups". This table contains (1) the duplicated song titles; (2) a brief description of the songs in question; (3) the name of the unique record in the songs table (basically the title of the song followed by the name of one of the writers).
For example, there are 10 songs with the title "My Love" in the database.
The corresponding records in DUPS look like this:
My Love Petula Clark hit My Love Hatch
My Love Paul McCartney & Wings song My Love McCartney
My Love Stevie Wonder song My Love Wonder
My Love Lionel Richie hit My Love Richie
My Love from "Candide" My Love Bernstein
My Love recorded by Bing Crosby My Love Young
etc.
I recently ported this db to Access from an obsolete db system called KnowledgeMan. Attached is a screen shot of the page that appeared in KnowledgeMan. I would like to have something similar come up in Access.
Obviously, I need to create a form called DUPS that displays the information from the DUPS table. I think I can do that, but then how do I get that form invoked from the main entry screen?
Thanks in advance.