If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
i have a good 'schema, where do i go from here?
Hi, I have used this and many other forums to develop what i believe is a
good table layout and have established my relevant relationships between the tables. My knowledge of Access is limited (i have built DB's but a long time ago). I am now trying to build the second phase of my database, the queries. My DB is a water sports booking system and we are run on a low budget so i can not afford to get this done professionally. The functionality i need is to: Add/remove Courses Add/remove Sessions to the courses (a course may run 5 sessions a year) Add/remove members to each course I require a lot more functions down the line but this is the basics of my DB. I am not sure were to start with bringing all the tables together to get the desired results. This is my table layout: tblMembers -pkMembersID -txtFirstName -txtLastName -fkRank -txtNumber -txtAddress1 -txtAddress2 -txtCity -txtCounty -txtPostcode -txtMil -txtTel -txtMobile -txtEmail -ActivInd tblRank -pkRankID -txtRank tblCourses -pkCourseID (1 to many link to fkCourseID) -fkCourseType -numMax (maximum places available on the course) -curPrice -logIsAvailable tblCourseType -pkCourseTypeID (1 to many link to fkCourseType) -txtCourseType tblSessions -pkSessionID (1 to many link to fksessionID) -dteStartDate (session start date) -dteEndDate (session end date) -fkCourseID tblSessionMembers -pkSessionMembersID (1 to many link to fkMembersID) -fkSessionID -fkMembersID -logPaid -logInstructionsSent -numPlacesRequired Where do i go from here? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/201006/1 |
Thread Tools | |
Display Modes | |
|
|