Newbies Bill Richter Posted June 27, 2019 Newbies Share Posted June 27, 2019 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? Link to comment Share on other sites More sharing options...
bcooney Posted June 28, 2019 Share Posted June 28, 2019 (edited) "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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1763 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now