S
Sharon
I have a table called "tblReceipts" and from this table I have to choose one
of three things to do with each receipt: Purchase Order, Check Request or
Expense Report. I have a combo box that drops down with these three items
and when i select one, it automatically goes to that form, i.e.,
frmPurchaseOrder, frmCheckRequest, frmExpenseReport. I also have a field in
the "Receipt" table that pulls information from another table
"tblMethodofPayment", which fields are "Cash", "MasterCard", "PersonalCheck"
and "CompanyCharge." Then I have done a query for selecting only the
"ReceiptID" records that are "ExpenseReport" items that were paid by
"MasterCard". So far all is well!
I then tables tblMasterCard and tblMasterCardDetails with the following
fields:
tblMasterCard: MasterCardID, StatementClosingDate, ExpenseReportID,
tblMasterCardDetails: MCDetailsID, MasterCardID, MCReferenceNo, MCSaleDate,
SupplierID, MCItemAmount and ReimbursementCheckID.
There is a one (MasterCardID) to many (Receipts) relationship, right?
The end results is that I want to show which MasterCardReferenceNo for each
ReceiptID and then show which Reimbursement Check paid each receipt.
I appreciate any help. I have tried to explain as best I can, but if anyone
needs further clarification, just let me know. Thanks.
S
of three things to do with each receipt: Purchase Order, Check Request or
Expense Report. I have a combo box that drops down with these three items
and when i select one, it automatically goes to that form, i.e.,
frmPurchaseOrder, frmCheckRequest, frmExpenseReport. I also have a field in
the "Receipt" table that pulls information from another table
"tblMethodofPayment", which fields are "Cash", "MasterCard", "PersonalCheck"
and "CompanyCharge." Then I have done a query for selecting only the
"ReceiptID" records that are "ExpenseReport" items that were paid by
"MasterCard". So far all is well!
I then tables tblMasterCard and tblMasterCardDetails with the following
fields:
tblMasterCard: MasterCardID, StatementClosingDate, ExpenseReportID,
tblMasterCardDetails: MCDetailsID, MasterCardID, MCReferenceNo, MCSaleDate,
SupplierID, MCItemAmount and ReimbursementCheckID.
There is a one (MasterCardID) to many (Receipts) relationship, right?
The end results is that I want to show which MasterCardReferenceNo for each
ReceiptID and then show which Reimbursement Check paid each receipt.
I appreciate any help. I have tried to explain as best I can, but if anyone
needs further clarification, just let me know. Thanks.
S