Novice needs help

[SeeAll]

Hi,
I am at present working on a database to store 1861 UK census returns.

On the occupation field - which is a drop down list - once entered I need these details storing in two tables. The table with all the census information and a separate table for occupations only. When the record is stored both tables need updating. So that when a new occupation is added it is available for the next record.

I am keeping individual districts separate so I want to access the occupations when entering data for other areas.

Can anyone suggest a way in which I can do this.

Regards

J

 

[Allen Browne]

Can you have a single Text field in the table of Occupations?

If so, you can use a combo box for entering the occupations in the Survey
table. Set the combo's LimitToList property to Yes, and use its NotInList to
append the value to the Occupations table.

Details in article:
NotInList: Adding values to lookup tables
at:
http://members.iinet.net.au/~allenbrowne/ser-27.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi,
I am at present working on a database to store 1861 UK census returns.

On the occupation field - which is a drop down list - once entered I need
these details storing in two tables. The table with all the census
information and a separate table for occupations only. When the record is
stored both tables need updating. So that when a new occupation is added it
is available for the next record.

I am keeping individual districts separate so I want to access the
occupations when entering data for other areas.

Can anyone suggest a way in which I can do this.