alpertunga65
Registered User.
- Local time
- Today, 23:48
- Joined
- Mar 15, 2013
- Messages
- 21
Hello,
I have three tables named as; Tbl_Shopowners, Tbl_Shops and Tbl_City
Main table is Shopowners, the second shops and the last one is city.
Tbl_Shopowners has fields as; OwnerID, OwnerName and a checkbox.
Tbl_Shop has fields as; ShopID and ShopName
Tbl_City has fields as; CityID, ShopName, ProductName and Price
And I am using one form with subforms for my records.
The First STEP;
At first step; OwnerName, ShopName and Product name values are not so important. The only important thing for me is, if the city name is the same with the previous record, then Price must be doubled authomaticaly when compared to the previous record. Each record must compare with the previous one.
Else, if the city name is not same, then price is free. Here, the criteria is CITY NAME for the price.
The Second STEP;
OwnerName, checkbox, City Name and Price are important for me.
Only for shops and their owners in the same city, if I will turn checkbox as "yes", then prices will double for any product in these shops. But here, both shops and their owners are important. I mean, there maybe more than one shop owner in the same city. So this event will turn for each owner and his shops seperately.
is it possible to do with Access2003.
Thanks a lot.
I have three tables named as; Tbl_Shopowners, Tbl_Shops and Tbl_City
Main table is Shopowners, the second shops and the last one is city.
Tbl_Shopowners has fields as; OwnerID, OwnerName and a checkbox.
Tbl_Shop has fields as; ShopID and ShopName
Tbl_City has fields as; CityID, ShopName, ProductName and Price
And I am using one form with subforms for my records.
The First STEP;
At first step; OwnerName, ShopName and Product name values are not so important. The only important thing for me is, if the city name is the same with the previous record, then Price must be doubled authomaticaly when compared to the previous record. Each record must compare with the previous one.
Else, if the city name is not same, then price is free. Here, the criteria is CITY NAME for the price.
The Second STEP;
OwnerName, checkbox, City Name and Price are important for me.
Only for shops and their owners in the same city, if I will turn checkbox as "yes", then prices will double for any product in these shops. But here, both shops and their owners are important. I mean, there maybe more than one shop owner in the same city. So this event will turn for each owner and his shops seperately.
is it possible to do with Access2003.
Thanks a lot.
