There seem to be many ways of tackling this and I have tried a number without success!
I have run a membership system and will be allowing subscription payments to be made via online banking. I can download bank transactions into Excel and then upload these into an Access table. However, the membership numbers from the Excel spreadsheet are not validated and may be wrong. Not all payments will be made at the same time, so there will be many interactions of the code over a few weeks.
So, I need to write some code that:
Loops through the Payment table;
Searches the membership table to check the existence of a valid member record;
If it finds a matching record, update the members record with payment date and update the payment record with an 'Success' status else update the payment record with a 'Failed' status.
Its a bit more complicated than that but it the use of the appropriate techniques for this logic that are causing me a problem.
Now if this was the 1960s using Cobol and Indexed Sequential files..........!
I have run a membership system and will be allowing subscription payments to be made via online banking. I can download bank transactions into Excel and then upload these into an Access table. However, the membership numbers from the Excel spreadsheet are not validated and may be wrong. Not all payments will be made at the same time, so there will be many interactions of the code over a few weeks.
So, I need to write some code that:
Loops through the Payment table;
Searches the membership table to check the existence of a valid member record;
If it finds a matching record, update the members record with payment date and update the payment record with an 'Success' status else update the payment record with a 'Failed' status.
Its a bit more complicated than that but it the use of the appropriate techniques for this logic that are causing me a problem.
Now if this was the 1960s using Cobol and Indexed Sequential files..........!