Data Help

[kgbo]

Is there a way that when data gets entered into the table via a form, that it changes into a different set of data?

For example:

If the name Jane Smith is selected into the form, and then saved to the Main Data table, it will instead show up as J1 on the table. Is this possible?

[RuralGuy]

The answer is probably yes but maybe you should explain what you are attempting to do and why. It will make it easier for us to assist.

[kgbo]

Just a headsup, I am slightly new to Access.
I have created a form that the user can select various inputs that I have created on different tables, linking it to this form.
When the user selects the data in the form and saves it, this populates a main data form.
Instead of the main form showing word for word of what the user selected, I would like to show corresponding numbers. In the example above, the employee Jane Smith is assigned the identifier of J1. So when the user selects Jane Smith on the form, the data table will, instead, populate it with J1. This is just to maintain some privacy within our organization. Thank you.

[RuralGuy]

ComboBoxes can easily do that but you could set it up so only Jane Smith could see that record. I'm still a bit in then dark. In a properly normalized database, the name Jane Smith would *only* be in one table. All other tables would contain a ForeignKey pointing tto the table with the name in it.

[kgbo]

Let me try to explain a different way.
There is a form with various fields to select data from using Comboboxes.
When the user then saves the form, it populates a Master Data table.
If one of the fields selected and entered into the Master Data table were say the name Jane Smith, is there a way for it to say J1 on this table instead of Jane Smith. I want to keep the combobox on the form saying Jane Smith.

[RuralGuy]

What is the RowSource of this ComboBox? Show the SQL view please.

[kgbo]

The RowSource comes from a seperate table: Employees. Within this Employee table it lists the Employees in the first column and their corresponding identification number in the second column.

[RuralGuy]

Does this Employees table have a field with the "codes" in it?

[RuralGuy]

Why not have an AutoNumber field in the Employees table as the PrimaryKey (PK) for that table and just store this PK in all of the other tables?