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
On Wed, 16 Apr 2008 04:57:06 -0700 (PDT), Paul
The way this would normally work is that you have one field, DeptID,
with a combobox on it. The combobox has a 2-column rowsource,
something like "select DeptID, DeptName from tableA". You set the ID
column to be invisible (width=0), and voila: you satisfy both your
table which wants a DeptID and the human who wants to see a DeptName.
-Tom.
>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