Drop Down Menus not working

[Bill Richter]

So I am fairly new to this and I am trying to get a inventory database set up. I am working on making the database a that is in 3nf. I am trying to pull information on a drop down menu from different tables. I have attached how they are related below. The input menu does not show me anything from the drop down menu, though there is data there. Do I need to create a desperate table for title data where I store information or am I missing a step to pulling the data from the other table?

[bcooney]

"The input menu does not show me anything from the drop down menu"

What input menu? Show us the UI with a screen shot in layout mode.

The table "Music Inventory abc" is oddly named. What does it represent? Can one music inventory item be used across multiple grades? Your data model does not allow that.

Are Arrangers and Composers people? Can an arrange be a composer and vice versa? I'd probably put them in a People table. You can name the table occurrences if you want for the roles. Perhaps add Indicator fields in the People table, ComposerInd, ArrangerInd. That's a simple form of a party model.

I'd suggest reviewing Library data models.

https://tinyurl.com/yyx47at6

Edited June 28, 2019 by bcooney
link to better data model