J
John
I clearly don't know how to do what I want
I am building a simple program to calculate total cost of an item
based on my cost plus profit plus shipping equals total
I have a POUNDS table with ShipPound and ShipRate (will later fill in
values from UPS) the ShipPound field is the Index
I have an ITEMS table with (among others) ItemPound and ItemRate
I used the Relationship setter to set a link between ShipPound and
ItemPound in the two tables
What I want (as a first step toward later calculation) is to enter the
item's weight in ItemPound on the form, and then have ItemRate loaded
from the pounds table
I used the Expression builder in the AfterUpdate function, which gave
me (the items table is the basis for the form, so is loaded/active)
=[ItemRate]=[Pounds]![ShipRate]
When I enter a value into ItemPound on the form, I do not have the
value from ShipRate loaded into ItemRate
I get an error... what am I doing wrong?
Thanks, John
I am building a simple program to calculate total cost of an item
based on my cost plus profit plus shipping equals total
I have a POUNDS table with ShipPound and ShipRate (will later fill in
values from UPS) the ShipPound field is the Index
I have an ITEMS table with (among others) ItemPound and ItemRate
I used the Relationship setter to set a link between ShipPound and
ItemPound in the two tables
What I want (as a first step toward later calculation) is to enter the
item's weight in ItemPound on the form, and then have ItemRate loaded
from the pounds table
I used the Expression builder in the AfterUpdate function, which gave
me (the items table is the basis for the form, so is loaded/active)
=[ItemRate]=[Pounds]![ShipRate]
When I enter a value into ItemPound on the form, I do not have the
value from ShipRate loaded into ItemRate
I get an error... what am I doing wrong?
Thanks, John