Main Problem is I want to ensure the database structure is correct so that I can convert it into Zoho Creator Form Combination (This is one element from a multi-function 50 Form application (Functions range from ordering products from suppliers to maintaining inventory etc...)

I can give access if necessary, I have attached a visual of the 'problem' as Design Specs.pdf and A copy of the already implement database in Zoho Creator (which works and I am happy with, I develop the relationships in Access for visual clarity)

I have been having difficulties getting this to work correctly in 'Form' mode and could use your help, as solving this will ensure the rest of the app is set-up correctly.

Each ‘Product’ has 1 ‘design’ and 1 ‘adjustment spec’

Each ‘Design’ can have many ‘possible adjustment locations’ and in turn each ‘Location’ can have many ‘designs’

Each ‘Design’ can have many ‘Adjustments’ and in turn each ‘Adjustment’ can belong to many ‘designs’ and many ‘products’

Each ‘Adjustment’ can have many adjust Locations (Locations should be related to the actual selected Design ‘Possible Adjust Locations’)

Each ‘Actual Adjustment Detail’ can contain many ‘Materials’

i.e. Design D01 has 4 Possible Adjust Locations S1,S2, S3, S4

i.e. When I Add a new Product I Select Design D01, then I should select the Adjustment for that design

I should be able to select from previously made adjustments or make a new a set of Adjustments

When I Select a new set of Adjustments only the Adjustment Locations related to Design D01 should appear for editing,

When I have added the materials to each Adjustment location, I want that configuration saved and available to use again in the future