I'm trying to make a database for my A levels and I've encountered a problem with a form.
I have a transactions table listing every transaction that takes place in the company. Some times certain things (like stock) will have a different Transaction ID assigned every time new stock of that type...