Hi everyone, I need help with a project I am working on for a new job. Only been using Access for two days.
I have been asked to create a database where we can input payment processing.
One requirement is that when we input a transaction that the bank batch field populates.
The bank batch field is in a separate table and is an auto generated number. However, my problem is that in any one day we need to use three different batch numbers, so for instance the table will be –
Batch Number Type
348 Cash
349 Credit Card
350 Cheque
351 Cash
352 Cheque
353 Cheque
Now I have a form that creates the batch number when needed.
When my problem lies here:
The user opens a form to input the financial data. From a drop down menu they select the payment type, from this I want the batch number to automatically come up with the last record in the table that matches.
So they may select ‘Cheque’ and I want Batch Number = 353
Please advise on how this can be accomplished.
I don’t have knowledge on writing code but I am starting to learn.
Thank you Toby.