Wow, thank you for all the amazing responses, I wasn't expecting so much help and insights. I will have a try tomorrow when I'm back at work and we'll see where we are.
I think linked tables is the key thing I was looking for, it solves a lot of problems I was facing when trying to create forms...