Hi Guys,
I need help setting up a dereference from these two tables. My Challenge is that the category column is already a reference to another table ( Category Types). I created the table Expense Category Database to store Category Types and am trying to match the Description Name (Key) to the Description on the Master Expenses Log.
Table 1: Master Expenses Log
Table 2: Expense Category Database
When [Description Name]=[Description], Reference the [Category ID] From Expense Category Database and set the Initial Value Of [Category] From Master Expenses Log to the [Category ID] .
