AnsweredAssumed Answered

Creating values for grouped items

Question asked by JohnDumas on Mar 31, 2009

Title

Creating values for grouped items

Post

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.

 

Any insights? 

Outcomes