I have two Tables in one portal. I am not sure if I have the relationship right because whenever I fill in the first field (table one) and then go to the second and third field (table two), with every new record, the second and third fields change across records.
This is my Portal:
& My relationship gets a little tricky in that I am producing a recipe using from a pool of ingredients, and with each new recipe, the pounds and process type change. I used to have a recipe table but it had no information in it.
This then leads into a production and work log.
Can anyone help me understand why these repeats are occuring??