Schema question - attribute transaction record to contact or contact's company

[ML!]

I need some help with table structure.

I have tblCompany with company details and tblEmps with employee details. CompanyID is an FK in the employee tbl to identify their company. I have to track some subscription-like transactions.

One type of transaction is where a company allocates an amount for each employee. The other type tracks a withdrawal by an employee to spend.

I need ideas for the intermediary transaction table - how best do I allocate one type of trans to the employer and another type to their employees found in a different table?

TIA for your ideas.
ML!

 

[MarkK]

How much the same are these two types of things? Like, spending money is not the same event, even a little bit, as budgeting money. Do you need a budget table and a transaction table? The budget table would have a foreign key for company and employee. Employee expenditures is then only related to the the company via the employee.
Just a few thoughts,
Cheers,
Mark

 

[ML!]

Hey Mark...just logged on to the board and realized I had forgotten to respond to this post. I ended up using a junction table to match the schema of the CRM app we are migrating to. Thanks for your thoughts.