Creating values for grouped items
I'm trying to create a database that will allow me to insert values for an associated set of categories.
In my database, each Location is associated with a Scope, with Scopes in multiple Locations ( Location >----- Scope ). Each Scope is associated with a set of Steps ( Scope ----< Steps ).
I'm able to display the associated Steps in a portal on the Location layout. I want users to be able to enter values for these steps, which will vary by step by location. I know that the solution is going to have to relate the Values to both Location and Steps, but I can't seem to get the right relationship. I think it should be Steps ----< Values, but it doesn't seem to be working for me.