I am using Access 2010 (14) 64-bit
This is a bit of a strange one - I am trying to setup a database in order to demonstrate a tie in between active directory and the HR side of a business.
As such, I would like to select two fields from drop down menus that reference in Department and Location tables, but use this data to actually Populate the Personnel Records table rather than Query.
I know this is not normally best practice from a DBA perspective.
I have this setup already in Filemaker, just through using relationships.
However, I want to move to Access, as it is more industry standard and much lighter weight, so am trying to find the best way.
I have attached two pics of my filemaker database, and a zipped copy of my Access file.
I have never played with Access, so please be patient with me.
Thanks for your help in advance.