If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with table design
I am building a database of financial deals for companies.
I will build a table with company details, including a field called txtcompany and then another table with the details of the deals with a field called txtdealnbr and also a field called txtcompany to link to tblcompany. For each txtdealnbr there will be a field called txttotalline which represents the value of the deal. Now comes my question. Each deal needs to be analysed to show what percentage of the deal is either any one of 7 categories. So a deal could be 50% cat1, 20% cat4, 10% cat5 and 20% cat6. However the user wants to be able to view on a form all 7 categories even in the %age is zero. So do I have 7 fields to hold the percentage value for each category or do I build a table of categories and if I do how do I show the value of each on my form? How would I construct the tables and theirrelationships. Hope I've explained that clearly, any help would be apppreciated. Thanks Tony -- Why don't my grey cells communicate with each as fast as they used to? I hate getting old! Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/201002/1 |
Thread Tools | |
Display Modes | |
|
|