Recent content by RobM-C

does this work for a query or just a form?? sorry if these questions are stupid i just dont know what im doing

Well i have a table named Students and it contains: Student id, Name, College and i need to be able to search it by either student number or name what do you reckon is my best option? i dont fully understand the first link.... do i just enter that in the criteria section of the design view...

Is it possible to create a search query in access that will alow me search by text (i.e. name of a student) OR search by a number (i.e. student number) i mean like a query that would give me the option of searching for either any help much apreciated all the best rob

I presumed the reference number was going to be used as the primary keys?!! I understand, say for instance the third question "One university can hire many applicants in relation to a job description" that this is a one to many relationship between some element of university table and the...

so could i use the reference numbers i had to put into each table as the primary key? and am i only linking two tables per question or is there more than two? thanks for your help. sorry if im not making myself clear

Thanks i Understand that but i dont understand on what they are linked. i.e. on the first question should i link "university name" from the univerity table to "university" in the job description and then link the "skills" from job description table to "skills" of the applicants table!? i...

Hi first time poster here!!I really hope you guys can help me out because ive been trying this all week and it has to be submitted tomorrow and i just can't figure it out. This is part of a college question and i just cant figure out what way to establish the relationships. if someone could...