hi everyone,
i have a table called "Margin" and in this table i have a field also called "Margin"
In a form called "costing" I have an unbound txt field called "txtMargin"
in the same form i have two combo boxes, called ProductCategory and ProductCompanyName
what i would like to to is the below:
I want to enter a price in the txtMargin which will update the field "Margin" in the table "Margin" based on the value i choose from the combo ProductCat. The purpose is to run a query and see costing relults for single products which belong to the same product category.
Any help is highly apreciated.
Thanks in advance,
Manolis