Creating related records without duplicating
I have this relationship:
Project (project name) > (project name) Lot (item no) > (item no) Ingredients
When I creat a new lot, I want a project name associated with it. Yet, Every time I create a lot, it creates a project record. I tried putting "project name" unique value option on but it then won't allow me to create my lot.
Actually, I want to use the project layout to summarize the lot done through a portal. So 20 project records are 20 projects and not a duplicate project record for every lot I make that has the same project name.
How can I achieve this?