Originally Posted by
ArviLaanemets
The form with general food info will be continuous one, i.e. user sees info about several different food articles (of course you can have it as single form too, when you want this). Brand info is displayed in single form, and contains info about active food article in general food form. I.e. whenever user activates another row in general food form, the brand info form displays brand info for selected article (and allows the user update it), or is empty. Whenever any brand info is entered into currently empty brand info form, when another row is selected in general form, an new entry linked to general foods table is created in brand info table automatically.
Of-course it is possible e.g. to have a tab in main form, where on one page is displayed a continuous form with general food info, and on another also continuous form with brand info, but there is no way to link such forms together. You need a lot coding, to keep both of form synchronized, and even more of code to link brand info to specific food article whenever it is registered first time (probably some button in brand form is needed for this, when you are going with this approach). Too much hassle I think