V
Veli Izzet
Hi,
I have a table of products. (Products)
Now I want to be able to calculate the cost of each product.
The problem is, for each product, the number and types of ingredients
are different.
The recipe may consist of 3 items, or 6-7-8 items.
I tried to put 24 different fields with each item for the products table
(I know this is clumsy) (8 items-name,amount,unit price) and do the
calculation on the forms and reports, but when a field is empty the
calculated fields on the forms did not work.
It seems that I need to have another table, "costs", and it must be
joined by a one-to-one relationship with the products table.
I tried to create this, but everytime I can only create one-to-many
links with the wizards.
The questions:
1-Am I in the right direction?
2-How do I create the one-to-one relationship?
Thanks for answers.
I have a table of products. (Products)
Now I want to be able to calculate the cost of each product.
The problem is, for each product, the number and types of ingredients
are different.
The recipe may consist of 3 items, or 6-7-8 items.
I tried to put 24 different fields with each item for the products table
(I know this is clumsy) (8 items-name,amount,unit price) and do the
calculation on the forms and reports, but when a field is empty the
calculated fields on the forms did not work.
It seems that I need to have another table, "costs", and it must be
joined by a one-to-one relationship with the products table.
I tried to create this, but everytime I can only create one-to-many
links with the wizards.
The questions:
1-Am I in the right direction?
2-How do I create the one-to-one relationship?
Thanks for answers.