Automating Field Values

[Thernan102]

I have a Brands table which contains three fields which
are BrandID, Brand, MarkUp. I also have a products table
which contains the fields Sku, Description, Cost, Price,
BrandID. In my form, after I enter the BrandID I want a
markup field to synchronize with the markup of the Table:
Brands so that the price field is equal to the cost field
times the markup field. How can I do this.

 

[Rebecca Riordan]

Couple of ways, but the most straight-forward is to use a DLookup and
calculate the value in the OnChange or OnExit of the BrandID control. If
performance becomes a problem, you can use a query, but that will require a
little fiddling.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...