field duplication

[synergy46]

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have 2 tables:

#1) Checking Account:
      Date / Payee / CATEGORY / etc.

#2) Budget:
      CATEGORY / Amount

I would produced the Checking Account as a LIST and it works well.

I have produced a pivot table of unique Checking CATEGORIES and can pair them with the appropriate budget amount. Great.

But, when the user types in a 'new' Category in the Checking Account, I would like a corresponding entry to be made in the Budget Table.

Anyone know how I can go about this?

Thanks