Tissot Posted October 31, 2007 Share Posted October 31, 2007 Hi, I’ve been looking for ages and don’t seem to find any info on this relation. I need to be able to give individual customers discounts on different Product categories. When the Product is selected, the Line item should get that Discount from that specific customer. How do I get those categories to display on the Customers Contact so I can apply a discount on each of the categories? How do I relate this Info? Am I dumb or is this really that hard? Looking forward to your reply! Thanks Ron Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 31, 2007 Share Posted October 31, 2007 (edited) Hopefully do you have a relational structure similar to the attached image, what I use is that the category an item belongs to is used to get the right discount value in the other end of the chain of TO's, I've according to the nature of being a historic snapshot used autoenter fields to get the price as well as the discount ... so if you later raise or lower the price or discount-rate won't it affect the previously issued invoices. I autoenter the discount by using this calc: GetNthRecord ( Discounts::Discount ; Items::Category ) This way could each customer have his/her own say 10 discount rates, the category in the chosen item redirect to right one of the 10. --sd Edited October 31, 2007 by Guest Link to comment Share on other sites More sharing options...
comment Posted October 31, 2007 Share Posted October 31, 2007 I believe the core structure should be more like this: Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 31, 2007 Share Posted October 31, 2007 Doesn't it allow several discounts for each category/customer associations??? Do you mean that quantity also makes the selection?? --sd Link to comment Share on other sites More sharing options...
comment Posted October 31, 2007 Share Posted October 31, 2007 Even if quantity is not a factor, the relationship between Customers and Categories is still many-to-many: Customer 1: • Products in Category A - 10% • Products in Category B - 7% Customer 2: • Products in Category A - 5% • Products in Category B - 3% Link to comment Share on other sites More sharing options...
Søren Dyhr Posted October 31, 2007 Share Posted October 31, 2007 So put RG'ish instead of ERD'ish do you mean this? --sd Link to comment Share on other sites More sharing options...
comment Posted October 31, 2007 Share Posted October 31, 2007 Probably - haven't tried implementing it myself, but it seems about right. Link to comment Share on other sites More sharing options...
Tissot Posted November 2, 2007 Author Share Posted November 2, 2007 Thanks for that. It's working as required. I've got a Portal for the Discounts and a Dropdown for the User to select a Category in it. Is there a way to get FM to filter already selected Categories? Otherwise the User could use the same category multiple times, resulting a conflict. Regards and once more thank you! Ron Link to comment Share on other sites More sharing options...
Søren Dyhr Posted November 2, 2007 Share Posted November 2, 2007 Is there a way to get FM to filter already selected Categories? Yes, pretty easy actually! http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000735 Just remember that the keyfields on both sides are bound to be of the same field type! Due to use of List( must both sides be text. --sd Link to comment Share on other sites More sharing options...
Tissot Posted November 3, 2007 Author Share Posted November 3, 2007 Thanks! Works great. Regards Ron Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6111 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now