J
June
I have created several tables. Some have "approved forms"
for various years starting with the year 2001 - 2004. The
other contains "pending approval forms" for these years
2001 - 2004".
I need to know how I can relate this one table with
the "Pending Approval forms" to the several tables
with "Approved forms", such that when I enter the date of
approval in the pending ones it corresponds with the
approved table.
The details in these tables are:
Field, Name of Project, Supplier, Invoice Number, VAT
Amount, DA1 Number, Applied on, Apprved On, Applied By and
lastly AT/IN.
for various years starting with the year 2001 - 2004. The
other contains "pending approval forms" for these years
2001 - 2004".
I need to know how I can relate this one table with
the "Pending Approval forms" to the several tables
with "Approved forms", such that when I enter the date of
approval in the pending ones it corresponds with the
approved table.
The details in these tables are:
Field, Name of Project, Supplier, Invoice Number, VAT
Amount, DA1 Number, Applied on, Apprved On, Applied By and
lastly AT/IN.