Is it possible to make a value from a relationship that has a many to many join table. 1stIngredient Table ID BaseUnitTypeIDfk Name BaseUnitIDfk 2ndJoin Table: For Ratio of different Types

[Siri]

Is it possible to make a value from a relationship that has a many to many join table.

1stIngredient Table

ID

BaseUnitTypeIDfk

Name

BaseUnitIDfk

2ndJoin Table: For Ratio of different Types

ID

IngredientIDfk

BaseUnitTypeIDfk

TypeIDfk

Ratio (between Type of Ingredient and a second type)

3rdType Table

ID

TypeName

4th Unit Table

ID

UnitName

TypeIDfk

Each Ingredient has a baseunit and a basetype. You can define ingredient specific units like clove (garlic). In the many join table you can create a ratio to other more standard types like mass in g or to other ingredient specific types like head (garlic). There you create a ratio like there are 22 cloves in a head of garlic.

I'd like to have a value list that I could reuse in other table's layouts that show the units that are related to the types that have been defined for one ingredient. If the unit doesn't appear the user would have to define a new type ratio.

Here is a sample file with the unit conversion.

unittype.zip