G
Guest
I have a database with one main table and several forms generated from
different queries. The data being entered are different types of accounting
adjustments: checks/wires, write offs, money movement between accounts, etc.
All records are stored in one table, called "Adjustment Table", but each
different type of adjustment is entered through a different form.
I have a version of this database where each field on each form is
different; i.e. there are 8 different fields for "Date Processed", 8
different fields for "Amount", etc. I am trying to simplify all of these so
only one "Date Processed" field is necessary. However, when I do this and
then enter information into one form, that record is viewable on every form;
if I enter a check in the "checks" form, it is viewable in the "write offs"
form as well. In the old version, if I enter a record in the "Checks" form,
it is only viewable from that form (if you click datasheet view or if you
scroll through the records individually). I realize this is mostly because
most of the fields are different for each form.
Is there a way to make 8 different forms, based on 8 different queries,
using many of the same fields in each (date, authorized by, department,
amount, etc) and make it so if I open the "Adjustment Table" I can see every
record entered but when I open a specific form, I can only see the items
entered via that form?
different queries. The data being entered are different types of accounting
adjustments: checks/wires, write offs, money movement between accounts, etc.
All records are stored in one table, called "Adjustment Table", but each
different type of adjustment is entered through a different form.
I have a version of this database where each field on each form is
different; i.e. there are 8 different fields for "Date Processed", 8
different fields for "Amount", etc. I am trying to simplify all of these so
only one "Date Processed" field is necessary. However, when I do this and
then enter information into one form, that record is viewable on every form;
if I enter a check in the "checks" form, it is viewable in the "write offs"
form as well. In the old version, if I enter a record in the "Checks" form,
it is only viewable from that form (if you click datasheet view or if you
scroll through the records individually). I realize this is mostly because
most of the fields are different for each form.
Is there a way to make 8 different forms, based on 8 different queries,
using many of the same fields in each (date, authorized by, department,
amount, etc) and make it so if I open the "Adjustment Table" I can see every
record entered but when I open a specific form, I can only see the items
entered via that form?