Auto pupulate field in table

[Tskutnik]

Help!!!! I have a table ([AllNames]) that a field ([Past_Employers]) is being auto-populated, and I don't want it to.

[Past_Employers] population is setup form a form, which references a separate table of employer names [Employers].

If I enter a new record directly in the [AllNames] table the [Past_Employers] field populates.

[Past_Employers] is a multi-value field (yes ugh - I know!!!) and is not required.

Any ideas would be welcome.

 

[CJ_London]

[Past_Employers] is a multi-value field (yes ugh - I know!!!) and is not required.

You know you have 'done wrong' with a multivalue field so remove it (and the lookup) and do it properly. At best, multivalue fields are for a basically fixed range of options - red, blue, green, not an forever extending list of options

 

[Tskutnik]

Thanks for that.
So then I have a question - what is the best practice to setup multi-value responses?
Each record in the [allnames] table needs to be populated with a varying number of employers - some records will have 1, some will have 10, etc...

Obviously one combo box with multi-value responses is a clean way for the user to select employers, but if multi-value is bad practice how should I setup both the forma and the related table.

Do I have separate fields in the table and form for Select Employer 1, select employer 2, etc... seems sort of sloppy.

Also - I'm not sure if this really helps with the first problem - the auto populate issue. I wouldn't expect it to auto populate just because it is a multi-value field.

 

[jdraw]

Please show readers your tables and relationships (printscreen of relationships window will work). It would also be helpful to readers if you could give us an overview description of your database in plain, simple English.

 

[CJ_London]

you have a separate table with as a minimum

employeeid
previousemployerid - or perhaps previous employer name, it depends on how frequently they are 'reused' by other employees

you may also want to have from and to date fields in this table and other details like job role, salary etc