I am designing a schoolinformation database. I created my tables but when creating Entity relationship diagram. I'm having a lot of problems. When runnig queries. I have duplicate data. Here are my table fields. If there is anything that needs to be added or changed please show me. (* represents primary key and ** foriegn key)
I got it to view the records now so thanks for your help. But I would like help in creating command boxes. I could get it to go to next record or previous, but I have problems getting it to add a new record in the form. Another problem is when go to next record it stops and give me an error. I would like it to go to the first record. I know you would have to go into the event procedure but I don't know the code.