Populating a Table with Data based on drop down boxes (not queries or lookups)

[gtiller]

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.

[RuralGuy]

Not real sure what the question is. Where are you having trouble?

[gtiller]

Thanks for your reply!

I would like to be able to auto populate my street, city and post code fields based on the selecting the location drop down box.

However, I want to populate the personnel table with the values, rather than simply lookup and display in the form... because I need to pipe the personnel table into another system.

[RuralGuy]

ComboBoxes have a Column() property that allows you to access each column. It is zero based so Me.cboName.Column(0) is the 1st column.

[gtiller]

thanks RuralGuy, but not too sure what you mean?
Are you suggesting that I should make the Street, City, and Postcode fields into ComboBoxes too?
Sorry for being thick

[RuralGuy]

Here, I got you started.

[gtiller]

Thankyou so much!

This has really helped me get my head around access - you have been a great help.

[RuralGuy]

Glad we could help. Have fun.