Hi Guys,
I'm a newbie of the crowd and I've a problem.
This is the situation:
I have 3 tables, and relative forms.
The first tab is a list of "product_parts" with name and specific characteristics, size, weigh, technical stuff, etc.
The second is a list of "products" with name, and product characteristics.
For each products are related different "product_parts", then
The third tab is a list of "product_parts" related to one product with relative calculations.
(I can say, it look like an invoice form with sub_form, a one to many relation)
Into the tab3, I input the "name" of the product parts choosing from a list box connected to tab1,
then I input the quantity, the cost and then I have some calculation fields based on data fields of tab1,
in the corresponding record of the specific "product_parts" selected, related to quantity and cost.
Here is where I am.
I can't access to corresponding data fields of tab1 from calculation fieds on tab3.
How can I take data related to a specific "product_parts" from tab1 fields and get them available in tab3?
I tried in a few way with query but didn't work.
I hope I was clear. Maybe it's a silly thing,
Can you suggest me something, please?
Thanks for your time.
I'm a newbie of the crowd and I've a problem.
This is the situation:
I have 3 tables, and relative forms.
The first tab is a list of "product_parts" with name and specific characteristics, size, weigh, technical stuff, etc.
The second is a list of "products" with name, and product characteristics.
For each products are related different "product_parts", then
The third tab is a list of "product_parts" related to one product with relative calculations.
(I can say, it look like an invoice form with sub_form, a one to many relation)
Into the tab3, I input the "name" of the product parts choosing from a list box connected to tab1,
then I input the quantity, the cost and then I have some calculation fields based on data fields of tab1,
in the corresponding record of the specific "product_parts" selected, related to quantity and cost.
Here is where I am.
I can't access to corresponding data fields of tab1 from calculation fieds on tab3.
How can I take data related to a specific "product_parts" from tab1 fields and get them available in tab3?
I tried in a few way with query but didn't work.
I hope I was clear. Maybe it's a silly thing,
Can you suggest me something, please?
Thanks for your time.