I have a number of different expenditure types (Labour, Plant, Materials). I have split these into different tables e.g. Labour: LabourID, Description, GradeID, Rate. Materials: MaterialID, Description, UnitCost, UOM. Etc.
I then want to have an Expenditure table where I store instances of these expenditure types against tasks, e.g. Task, ExpenditureTypeID (from labour/materials/plant).
The problem I have is that I have split the expenditures up into different tables and I then want to store the instances in one table. Is this possible?