Search results

  1. C

    No duplicates on a one to many table

    Hi I have a table full or resources that can be categorised as many different types of categories. i.e. tblResources has a one to many relationship with tblCategory. if i could categorise a resourse as either a 'Listening' resource or a 'Reading' resource this relationship would capture it...
  2. C

    Joins to the same table

    Hi there, if i have a table with columns: Teacher ID1 | Teacher Comment1 | Teacher ID2 | Teacher Comment 2 | i also have another table that links the teacher ID with their names called [Staff Profiles] how do i create a query that returns the names of both teacher 1 & 2. i have tried: SELECT...
  3. C

    edit button for tabular view

    hi there, i have a form (to be used as a subform). I have added a button to the form so that records can be edited. attached to this button i have written a macro to unlock the text boxes (when pressed). Please find diagram attached. My problem is that the button unlocks all boxes in all...
Back
Top Bottom