Recent content by emmily11

Hi Pat, thanks for the response i have only just replyed because ive been finishing the database all week its all done now so thanks for all your help emmily

hi pat i only did the other thread because this one wasnt on the list for some reason i thought i had done something wrong so i posted it again sorry for annaoying everyone i didnt mean it thanks for your reply i relly appreciate it Emmily

hi pat im a bit confused yes it does mean that each student has 3 supervisors so the relation table s that a junction box?? also cant i store the supervisors in a table with the student id and the supervisor types as fields and then the supervisor codes as records???? i realy dont know how to...

hi i have tables called staff external and student some of the staff and some of the external people will be supervisors but not all of them the students have 3 supervisors i have now created 2 more tables called external supervisors and staff supervisors and given them an id eg STAFFSUP23...

hi i have a tables called tblstaff, tblexternal, and tblstudent if the external person or staff member is a supervisor i need this in anothe table to give them a supervisor id eg EXTER09 for externel supervisor INTER09 for staff Supervisor this then needs to be linked to the students table...

hi jack thanks for the help i am goin to read the link you gave me and i hope that helps i dont understand the rae table where you have put year how wil i record the previous years answer y/n and how will the year not become obsolte thanks again emmily

hi, i know my tables arnt even slightly normalized and that the feilds arnt wholely dependent on the primary key but i just dont know how to do it The rae table just needs tick boxes for the years (yes or No) its the only way i could think of doing it otherwise next year or in a few years the...

hi i am trying very hard to build this daabase i dont think there will be a problem when it comes to the forms etc but just getting the tables linked right is becoming a big issue here is the relationship diagram if someone could look at it and give me some advice i would appreicaiate it i know...

thanks Hi Pat, thanks for the advice i got it to work by writing !"C" & that works fine now thanks for all your help thanks again i really appreciate it emmily

cant get it to work hi i have tryed what you said and it is a much better idea thanks but when the auto number gets to double figures it is split by the C e.g. C: 9 1C: 0 1C: 1 do you know how i can get this to stop thanks emmily

hi i have created an input mask for customer ID (>"C":00999) instead of the 00and 99 is there anyway to make this an automatic number so the user wouldnt have to try and find the next available customer id number also is there any way of creating a e-mail input mask thanks for your help emmily

hi could anyone help and tell me if the relationship is in 3rd normal form thanks emmily

i have a report called invoice and fields calld quantity and unit price i have then calculated these in the form to give a total for each product in the page footer i am trying to calculate all the numbers in the totals colum and have tried everything i can think of please help at the minute i...

sorry hi sorry for posting on the different forums i didnt know what section to put it in where me. should i put the name of the database or should i put me. thanks

sorry hi sorry for posting on the different forums i didnt know what section to put it in where me. should i put the name of the database or should i put me. thanks