Billing Database Change

[Guest]

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?

 

[Guest]

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