I've made a small database that when you input the data in the form it is saving it in the appropriate tables correctly but when you close the form and re-open it all the data has gone. I think this is either a relationship issue or a source issue.
I also need to create a report based on the data input into the form but i get an error saying too many fields defined when i use the report wizard. I need this issue fixing as well. I dont want you to design the report i just need the fault fixing so i can design it myself.
## Deliverables
Database is attached with template images. i dont want the design work done just the database side fixed