Auto Populate a Field

P

Paul

I have a table with a list of departments & Dept IDs (table a) and
also a master table (table b).

When staff are completing an input (this is saved in the master table
b) they fill in multiple data which also includes their department
which is selected from a drop list (feed from table a) I want the
'Dept ID' field to be automatically populated depending on their
selection.


Can anyone help please
 
T

Tom van Stiphout

On Wed, 16 Apr 2008 06:54:48 -0700 (PDT), Paul

already answered in comp.databases.ms-access
-Tom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populate a field 0
Auto populate a cell based off a look up table 2
[Q] Form/Subform auto list 3
Lookup field 5
Table Design: Tests required for some but not all. Where to tell thedifference. 2
How do you populate a listbox based on a combo box selection in ms access? 1
Access 2007 - Table A lookup values based on Table B 1
Auto-Populate Form Field 1

Top