hey,
i am a beginner using Access and am currently trying to create a school trip database. Yet i am having some trouble setting up my tables and relationships. I have four tables - Student, Trip, Payment and Student Trip. I have the following relationship setup but cannot make it work.
how would i make this work and do i have the right tables etc? What is the relationship that is required from the payment table? hope someone can help
thanks
i am a beginner using Access and am currently trying to create a school trip database. Yet i am having some trouble setting up my tables and relationships. I have four tables - Student, Trip, Payment and Student Trip. I have the following relationship setup but cannot make it work.
how would i make this work and do i have the right tables etc? What is the relationship that is required from the payment table? hope someone can help
thanks
