Jump to content

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

This topic is 6454 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 6454 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.