I seem to over-think and then I get stuck.. I'm working on a rather 'simple' access DB.
What I am trying to accomplish- every day, and sometimes multiple times a day we make bank deposits. There may be one check, or 20. Also, there are multiple departments that they get assigned to.
The foundation is going well, but where I am getting stuck is;
1- How would I be able to store, multiple lines of data in to one record for that particular deposit.
i.e; the fields for each check would be : Department, amount, check number and reference.
But all kept in one record...