Search results

  1. W

    Linking all fields to each record

    Pat, thanks for the tip. I was using the look-up function but have now changed as you have suggested. All working perfectly now. Thanks again.
  2. W

    Linking all fields to each record

    I have now tidied up my tables and all working perfectly. Many thanks to everyone for the help. If you are interested. Updated Relationships attached.
  3. W

    Linking all fields to each record

    Hi plog, attached Relationships as they are at present. I have not made any changes yet to add in the Junction table etc mentioned above.
  4. W

    Linking all fields to each record

    Guys, many thanks for your help. All working now. On a separate not:, how should I have set up my database in the first instance, i.e. was creating two tables (60+ projects and 60+ checks) the correct way to do it? (to avoid the need for a hack!)
  5. W

    Linking all fields to each record

    Thanks for the quick responses. Firstly, I created two separate tables because I have 60+ projects each requiring 60+ checks, so to create one table would be huge. As each project requires each check it seemed the sensible approach. I have created a main form and sub-form as suggested but when...
  6. W

    Linking all fields to each record

    Hi, I am trying to create a database to record quality checks against each project. I have one table called "Projects" which contains all current project details and another called "Checks" which contains all quality checks required for each project, plus comments, dates etc. Basically, I need...
  7. W

    Hello from Scotland

    Hi everyone, New to the forum and relatively new to Access so thanks in advance for any help/tips.
Back
Top Bottom