Recent content by johnnyguy

hi for my database there are a number of courses which students can study, inside each course there are a number of subjects (Many subjects to One Course), i wanted a form where i can choose the course concerned using a combo box and then view details of the course, then underneath enter new...

hi, i have a code being created for lecturers using the initials of lecturer names inputted. for example john smith = JS, i have also added a variable called codenumber which i have used to add a number to the initials. JS1, as more than one lecturer may have the same initials. I do not know how...

hi thanks for that i now have a button on the form to generate a code of 2 letters from the surname and forename, does any1 know how i could do a check to see if those letters already exist in the table. so i would generate cb01 and then if another cb came along it would automatically become...

hi again thanks for the help with the last problem i had, i think ive sorted that now. but i have a new one. :mad: im trying to create a code representing tutor names for the same database, for instance if i type in charles brown into the form, the tutor_code field is automatically filled in...

Hi i have just joined and am having trouble linking 2 tables with composite primary keys. The relationship type i want is 1 to many but it only allows indeterminate and wont allow any cascading! the field in question (Class_No) looks to be the same in both tables the only difference is it is a...