B
babs
From Previous Post
I have a table that has a delivery yard, pickup yard, and type of
material(2choices). Based on that combination of what is in those three
fields there is a given RATE. On the form based on this table I would like
the rate to automatically fill based on the combination of the 3 fields
chosen. Seems like it should be easy not sure where I go with this.
Thanks,
Barb
John Vinson 8/31/2006 12:54 PM PST
I'd suggest creating a Rates table with four fields - these three as a
joint Primary Key and the corresponding rate. You can then create a
Query joining your current table to this rate table by the three
fields (two yards and a type) to look up the rate.
John W. Vinson[MVP]
babs 10/9/2006 11:30 AM PST
I did what was recommended below but am having an issue when trying to get
the rate pulled into a tankentryform -based on a query. Not sure what the
query should look like now?? Tried Dlookup on form but having issues with
when delvydnum same with differrent delivydnames. keeps pulling in 1st one
it sees?????
Actually need to have the rate dumped in (preput in- not a calculated
rate)in a RATEtable. Want the rate automatically put in based on actually 6
Fields not just 4 Clientid,pickupydnum,pickupydname, delivydnum, delivydname,
& typeofmat
I am having an issues with having
the same yard numbers for different del yard NAMES
Example:
Prairie Material’s yard # 15(Delivydnum) is Addison(delivydName)
Ozinga Concrete’s yard #15(Delivydnum) is Hampshire(Delivydname).
See prior posting
I'd suggest creating a Rates table with four fields - these three as a
joint Primary Key and the corresponding rate. You can then create a
Query joining your current table to this rate table by the three
fields (two yards and a type) to look up the rate.
John W. Vinson[MVP]
thanks,
Barb
I have a table that has a delivery yard, pickup yard, and type of
material(2choices). Based on that combination of what is in those three
fields there is a given RATE. On the form based on this table I would like
the rate to automatically fill based on the combination of the 3 fields
chosen. Seems like it should be easy not sure where I go with this.
Thanks,
Barb
John Vinson 8/31/2006 12:54 PM PST
I'd suggest creating a Rates table with four fields - these three as a
joint Primary Key and the corresponding rate. You can then create a
Query joining your current table to this rate table by the three
fields (two yards and a type) to look up the rate.
John W. Vinson[MVP]
babs 10/9/2006 11:30 AM PST
I did what was recommended below but am having an issue when trying to get
the rate pulled into a tankentryform -based on a query. Not sure what the
query should look like now?? Tried Dlookup on form but having issues with
when delvydnum same with differrent delivydnames. keeps pulling in 1st one
it sees?????
Actually need to have the rate dumped in (preput in- not a calculated
rate)in a RATEtable. Want the rate automatically put in based on actually 6
Fields not just 4 Clientid,pickupydnum,pickupydname, delivydnum, delivydname,
& typeofmat
I am having an issues with having
the same yard numbers for different del yard NAMES
Example:
Prairie Material’s yard # 15(Delivydnum) is Addison(delivydName)
Ozinga Concrete’s yard #15(Delivydnum) is Hampshire(Delivydname).
See prior posting
I'd suggest creating a Rates table with four fields - these three as a
joint Primary Key and the corresponding rate. You can then create a
Query joining your current table to this rate table by the three
fields (two yards and a type) to look up the rate.
John W. Vinson[MVP]
thanks,
Barb