I finally got my database to work properly and got an ruminary form up and working properly i can enter all the information correctly, now i want to enchance my form.
here's a picture of the structure of the database.
and here's a picture of the current form as it is now
Ignore the errors in...