[eluser]Unknown[/eluser]
Hi,
I have three tables as defined below
client
id, names, address ,telephone, email
entity
id, title, clientid, commission
payment
id, names, entityid, date, amount, balance
Question is, which relationship will i use to generate the following table
client.name, payment.amount, payment.balance, entity.commission, total*
total* = amount - (amount*commission)
Thank you in advance
