Search results

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 isavailable field i put is as i was advised on another forum. It is so i can make courses available or unavailable. I have changed the phone fields. Thanks

i have done my reading and i have attached a picture of my tables and the relationships i have setup. I have attempted to normalize it and as a result have created new tables. Let me know what you think.

I have put payment and joining instructions under session members: tblSessionMembers -pkSessionMemberID primary key, autonumber -fkSessionID foreign key to tblSessions -fkMemberID foreign key to tblMembers -logPaid yes/no -logInstructionsSent yes/no I am reading up on relationships...

My Table layout so far: tblMembers -pkMemberID primary key, autonumber -txtFirstName -txtLastName -txtAddress1 -txtPostcode -numTel -numMobile -txtEmail tblCourses -pkCourseID primary key, autonumber -txtCourseName -numMax (maximum places available on the course)...

Hi, i have just joined the forum and have built a few DB's in the past but found i have forgotten almost everything! I do remember with a previous DB i layed the tables out incorrectly which impacted on the flexibility down the line so would like advise before i start in order to get a good...