I am building a database of fruits and vegetables. I want to associate vitamins and minerals with each fruit, but I also want to capture the level of nutrition (none, good, great, excellent). I have a database for Produce and a database for Vitamins/Minerals. When I enter Apple in the database, I need to be able to associate it with Vitamin C and a value of Good (only for Vitamin C). I’ve tried setting up a separate database for Nutrition Level, but can’t figure out the right relationship linking (if that’s even the way to do it).
It seems simple in my Excel spreadsheet where I have Produce down the left, Vitamins across the top and then the value (Good, Excellent, etc) in the actual cell that intersects each record. How can I duplicate this using the database collections?