Recent content by jeffcampbell

Hi jzwp22, Thank you very much for helping me. Here’s some more info. My Junction Table, tblJunctionEmployeeAward has two fields, EmployeeID and AwardID. EmployeeID is a foreign key to tblEmployee and AwardID is a foreign key to tblAward. (both EmployeeID and AwardID are set to Primary Key...

Hi Everyone, I'm working on my first "real" Access database, intended to keep track of employee who receive recognition for performance. It quickly got more complex when it turned out that it required a "many to many" relationship, i.e. employee can recieve multiple awards, and an individual...

Hi Rainman, Thank you again for all your help, and for actually making something I could look at and try!! I never expected that someone go to that extent to help, you went above and beyond, and I really appreciate it. After experimenting, and looking at your sample, I figured out that I could...

Hi Rainman, I've been experimenting with the NotinList and the VBA, and I think I'm getting closer. The last issue I'm having is that although I've been able to get the NotinList & VBA to create a new record in tblAwards, the record doesn't seem to be linked to tblJunction and since there isn't...

Hi Rainman, Yes, that's my hope, the ability to have a single form where the end user can move through records in the employee table, see the associated awards for the employee, add employees as necessary, and add new awards which can then be associated with any of the employees. Thanks!!

I'm an Access newbie using Access 2003, and am a bit confused about how to create a form/subform (when I have two tables linked by a junction table) which allows the creation of new records in either of the two main tables. Here's the scenario: First table, tblEmployees, with three fields...