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

Dynamic Naming of Form Button 3
Auto populate a cell based off a look up table 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Access 2007 - Table A lookup values based on Table B 1
Adding a big matrix in Word 2013 5
How to populate other fields when a dropdown was changed 13
Table Design: Tests required for some but not all. Where to tell thedifference. 2
Pivot Table Calculated Field 0

Top