Hi thanks for the reply.

I think it looks like an EAV as I've effectively take an attribute and changed it to a row:

Before:

Expenditure

BudgetID

FoodAmount

FoodFrequency

FoodComment

FuelAmount

FuelFrequency

FuelComment

etc...

After:

Expenditure

Expenditure

BudgetID

ExpenditureItemID

Amount

Frequency

Comment

ExpenditureItem

ExpenditureItemID

ExpenditureItemName

-------------

Has anyone come across a similar issue for instance a parts table which have common attributes such as weigh, length etc.