Search results

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.

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.

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.

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!)

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...

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...

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