Search results

Thanks for the response Jdraw!

Excellent idea, thanks mate! Again, I appreciate the time you took to help.

Thanks CJ I agree with you on not needing the activity junction table. I do have a different table with personnel from which I look up the employee and supervisor name. How would you suggest a handle a scenario in which the employee's supervisor changes?

Many thanks for the reply! How does the junction table then get populated? Do I have to manual create records or would it get populated through the data that I enter in the related tables?

Hi all I am in the process of learning to make use of a junction table for many-to-many relationships and I think I'm starting to grasp it. My question is, once the tables and relationships have been set up, does the junction table get updated as you enter data into the fields on the two tables...

Hi CJ Thank you so much for taking the time to respond! I managed to get it sorted in a rather inelegant way I think (See attached screenshot) To answer your question, yes, the idea was that one month table record could be linked to several activity table records (One employee could have...

Hi All I am back to using Access after many years and I am shocked at how much I have forgotten! I have searched both this forum and the web but none of the proposed solutions that I have seen have fixed my problem so I'm going to rely on the gurus here! I have created tables to capture...