Hello all,
Can someone please help me to create a table for entering and monitoring a commission for each agent from buyers.. I have tables of buyers, payments and agents.. i hardly create a table which field to include in table commission.. i am thinking to put the id's from buyers, payments and agents as FK.. what would be my form (mainform + subform)?.
Every time a buyer make a payment, corresponding agent will be entitled a commission.. then i need to make a total, displayed on form the total commission of that agent from that buyer..
But again, my problem is, agents are not limited to one buyer, they have many buyers, (one-to-many).
Please need help.
Thank you,
Can someone please help me to create a table for entering and monitoring a commission for each agent from buyers.. I have tables of buyers, payments and agents.. i hardly create a table which field to include in table commission.. i am thinking to put the id's from buyers, payments and agents as FK.. what would be my form (mainform + subform)?.
Every time a buyer make a payment, corresponding agent will be entitled a commission.. then i need to make a total, displayed on form the total commission of that agent from that buyer..
But again, my problem is, agents are not limited to one buyer, they have many buyers, (one-to-many).
Please need help.
Thank you,