Good day,
Thank you for any suggestions!
I have a main and a sub form. The main form is based off a record set for my PDF Bank statements and has 3 fields: Account, Start Date, and End Date.
The sub-form is all of the transactions from the PDF statement, and its record source is a transaction table. It has a few fields, including 'Vendor' which shows the vendor by actual description through a relationship property in a combo box. The transaction table in itself only has the Vendor ID, which is the primary Key.
The problem is that some of these Transactions have corresponding 'Budget Accounts' and budget transactions -i.e my paycheck gets labeled as 'Salary' and a separate budget transaction gets created in a separate table.
Whereas the 'Vendor' example earlier was easy because on the 'Transaction Table', there is a field for the Vendor ID, and I could just set up a query in a combo box. However, it works in the reverse for the 'Budget transaction' table as the "Transaction" ID from the transaction Table has a field on the 'Budget Transaction' Table, not vice versa. I can get a combo box to populate with all of the budget account (which has a field on the Budget Transaction table) i.e Salary and Gas, but it isn't the correct corresponding value on for a given transaction.
I tried making a separate query to solve the solution, and it indeed gave me all the correct budget accounts with the correct corresponding Transactions, but it does not include Null values and not every transaction has a budget account.
Any ideas?
Thank you,
Kavy
Thank you for any suggestions!
I have a main and a sub form. The main form is based off a record set for my PDF Bank statements and has 3 fields: Account, Start Date, and End Date.
The sub-form is all of the transactions from the PDF statement, and its record source is a transaction table. It has a few fields, including 'Vendor' which shows the vendor by actual description through a relationship property in a combo box. The transaction table in itself only has the Vendor ID, which is the primary Key.
The problem is that some of these Transactions have corresponding 'Budget Accounts' and budget transactions -i.e my paycheck gets labeled as 'Salary' and a separate budget transaction gets created in a separate table.
Whereas the 'Vendor' example earlier was easy because on the 'Transaction Table', there is a field for the Vendor ID, and I could just set up a query in a combo box. However, it works in the reverse for the 'Budget transaction' table as the "Transaction" ID from the transaction Table has a field on the 'Budget Transaction' Table, not vice versa. I can get a combo box to populate with all of the budget account (which has a field on the Budget Transaction table) i.e Salary and Gas, but it isn't the correct corresponding value on for a given transaction.
I tried making a separate query to solve the solution, and it indeed gave me all the correct budget accounts with the correct corresponding Transactions, but it does not include Null values and not every transaction has a budget account.
Any ideas?
Thank you,
Kavy
