AllanMcPhail

2 years agoQrew Member

# Related Grandchild to parent

I am building a recipe database and need some help, I'm trying to get the related material components to show on the formula components.

The table structure is below.

The CAS Numbers are a list of items.

Materials are added before the formula is raised and have multiple material components.

Materials are added before the formula is raised and have multiple material components.

When the formula is populated with formula components I want the related material components to show in a report on the same form.

The formula shows the formula components as below

I would like to do this with relationships if possible due to them being more reliable.

------------------------------

Allan McPhail

------------------------------