shp10021
|
Posted: 09/13/2003, 7:08 PM |
|
I am developing a shopping cart based on the Bookstore example. A user logs
in and depending on the member_level, I would like the price field in Orders
to be updated with either the memberrate or nonmemberrate from Items. I
have the following tables with these fields
Items: itemid; memberrate; nonmemberrate
Login: loginid; login; password; member_level
Orders: itemid; loginid; price
Any help would be greatly appreciated.
|
|
|
Michael Rachow
|
Posted: 09/30/2003, 7:55 AM |
|
An idea:
Select both fields from the database.
Set field memberrate to Label and
nonmemberrate to Hidden.
In Event: Before Show
check for member_level and if to "low" set
fldmemberrate = fldnonmemberrate;
"shp10021" <shp10021@yahoo.com> schrieb im Newsbeitrag
news:bk0ijo$ivj$1@news.codecharge.com...
> I am developing a shopping cart based on the Bookstore example. A user
logs
> in and depending on the member_level, I would like the price field in
Orders
> to be updated with either the memberrate or nonmemberrate from Items. I
> have the following tables with these fields
>
> Items: itemid; memberrate; nonmemberrate
> Login: loginid; login; password; member_level
> Orders: itemid; loginid; price
>
> Any help would be greatly appreciated.
>
>
|
|
|
|