Search results

Thanks ever so much. I've (hopefully) attached a copy of the database (with dummy data obviously - I don't really teach these students!).

The tables are linked together with a one to many relationship on the FormID field. The main and subforms are linked together using the Master and Child fields in the Data Properties. Obviously I can't have FormName as the master and then the fk as the child because the data types are...

I have a problem. I have two tables which are as follows tblFormName FormNameID (pk) FormName tblStudents studentsID Surname FirstName FormNameID (fk) So, I've created a main form based on tblFormName, and a subform based on tlbStudents. What I want is a drop down box in the main form...

Hi, I'm new. I'm an ex-web programmer who used to do databases for websites using SQL, as well as playing around with Access. I'm currently looking at access and trying to design a database for use at work but am struggling to remember how to do things I used to know how to do!