Results 1 to 4 of 4
  1. 10-05-2015, 12:46 AM #1
    Stephenpoole4
    Stephenpoole4 is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Posts
    2

    Database to help me DJ?

    Essentially, I'm organizing songs in a few categories. I want to be able to search by song name and/or song key. For instance, if I search for the song "Stranger", I want to display the key for Stranger (which is the key of D) AND all other songs in my database in this key or a compatible one. For example, the song "Bounce Generation" is in the key of A. The key of A is compatible with the key of D. So I want all songs in A and D to be displayed.

    Any idea on how to create these tables and their relationships?
    Reply With Quote Reply With Quote
  2. 10-05-2015, 01:13 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Stephen

    Please read this link about cross posting: http://www.excelguru.ca/content.php?184

    Crossposted: http://www.access-programmers.co.uk/...d.php?t=281462
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 10-05-2015, 01:25 AM #3
    Stephenpoole4
    Stephenpoole4 is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Posts
    2
    I appreciate the correction. Would you be able to answer my question?
    Reply With Quote Reply With Quote
  4. 10-05-2015, 01:36 AM #4
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    Quote Originally Posted by Stephenpoole4 View Post
    I appreciate the correction. Would you be able to answer my question?
    Please see http://www.access-programmers.co.uk/...d.php?t=281462
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Help with Database User enteing database variable in text field for custom email.
    By russ0670 in forum Forms
    Replies: 1
    Last Post: 07-01-2015, 04:18 AM
  2. Automating Access Database Back-up from laptop to base desktop when I close database
    By Neil Bingham in forum Access
    Replies: 1
    Last Post: 03-21-2015, 11:55 AM
  3. Unable to Open Split Database after Physically Moving Database to a New Machine
    By LJ2013 in forum Access
    Replies: 4
    Last Post: 11-27-2013, 09:51 AM
  4. Access 2013 Web Database-Trying to display an image on a report with desktop database
    By kmcclaff in forum Reports
    Replies: 4
    Last Post: 08-21-2013, 07:08 AM
  5. Java UI for Access Database : Select Checkbox items and add them to a Database table
    By sandlucky in forum Programming
    Replies: 3
    Last Post: 05-15-2011, 10:52 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums