 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / July 2005Billing Database Change
I currently have a database set up with one table of agents, one of households, and one with actual accounts within the housholds. In the past we sent the agent the bill for their respective household accounts. Now we have more then one sales person being charged for one set of houshold accounts, say a 50/50 split. Before it was one agent to multiple households to multiple accounts, so I could sent a bill to an agent that showed the houshold accounts they were being billed on. Now it's one household with multiple agents and accounts. We currently have thousands of records, so creating a new database would not be an option. Does anyone have any suggestion on changing this to show an invoice to the agent with a percentage of the fee and send another agent their percentage of the invoice? Hi, I guess by now you have your solution, In case you have not, you can maintain your existing table, create a new table called agent, and have an unique field called agentid and tansfer all agent details to the agent table and create a field called agant id in the existing table and relaet the agent table and the existign table. Do you have a field that maintains the fee amount in the existing table? If so what you can do is write a piece of code so that evey time the agent goes for collection he can get from the remining amount. Say for example 100$, agent 1 goes gets 45, the next agent gets from the reminaing 55$, if the secodn once goes and gets 20$, the next one gets from the next 35$ etc. Is this what you were looking for? Anand  Signature"Who will guard the guards?" > I currently have a database set up with one table of agents, one of > households, and one with actual accounts within the housholds. In the past [quoted text clipped - 7 lines] > suggestion on changing this to show an invoice to the agent with a percentage > of the fee and send another agent their percentage of the invoice? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.