- Local time
- Yesterday, 21:08
- Joined
- Feb 28, 2001
- Messages
- 27,300
Prima facie, it appears that you have normalized your tables. You have blended all of your products into a single table, with brands and brand-based discounting. Your customer cards are covered as well.
Now, however, you will find yourself floating for a bit. The reason is that YOU are the project expert, so unless you have specific questions, you will have to work somewhat on your own. This doesn't mean we aren't here - but it does mean that in the absence of a question, we don't have an answer. (They kind of go together...)
You DID take our advice. It shows. You have started on a process for adding new or updating old customers. The details of that are up to you.
I might have played with moving the relationships around in the window to put all the "ONE" sides to the left and all of the "MANY" sides to the right, where possible. (Obviously, sometimes that is NOT possible.) The relationship drawing algorithm lets you do that and is pretty good about it. I should add: That grouping of ONE sides and MANY sides is a personal visual preference that DOES NOT indicate you did anything wrong. But if you try it, it is possible that you will see different factors about the relationships you have defined. Sometimes things like that "click" and sometimes they don't.
Now, however, you will find yourself floating for a bit. The reason is that YOU are the project expert, so unless you have specific questions, you will have to work somewhat on your own. This doesn't mean we aren't here - but it does mean that in the absence of a question, we don't have an answer. (They kind of go together...)
You DID take our advice. It shows. You have started on a process for adding new or updating old customers. The details of that are up to you.
I might have played with moving the relationships around in the window to put all the "ONE" sides to the left and all of the "MANY" sides to the right, where possible. (Obviously, sometimes that is NOT possible.) The relationship drawing algorithm lets you do that and is pretty good about it. I should add: That grouping of ONE sides and MANY sides is a personal visual preference that DOES NOT indicate you did anything wrong. But if you try it, it is possible that you will see different factors about the relationships you have defined. Sometimes things like that "click" and sometimes they don't.