ContributionsMost RecentMost LikesSolutionsRe: Related Grandchild to parent Thanks Mark. How would I get the related material components to show up under the formula. I don't see any relationship between the formula and the material components. With there being multiple formula components in a formula is there an easy way to get all of the related materials in the same report? ------------------------------ Allan McPhail ------------------------------ 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. 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 ------------------------------