Store Text Box data in a Table Field

[BradCustom]

thread181-1292653

I'm working on a form where I am looking up and Employee by their Employee ID then populating two text boxes with their First and Last Name. My question is can I store the text box data into a specific field in a table as I've done with the Combo Box that selects the Employee ID.

Thanks for your help!!

 

[Andrzejek]

Yes you can. But why?
In your table you have EmplID (PK), EmplLastName, and EmplFirstName
While I can see you want to have EmplID in other table(s) as FK, but I would not kepp EmplFirstName or EmplLastName anywhere else in any other table(s).

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[BradCustom]

The reason why is because the EmpID,EmplLastName, and EmplFirstName comes from a linked SQL table and on the form I'm entering additional information that will be stored in an Access table for use in a report. So, in order to keep the info unique I'd like to store the EmpID,EmplLastName, and EmplFirstName as well. I suppose I could store only the EmpID and in the Report pull the First and Last name from the SQL linked table.

 

[Andrzejek]

Your last sentence in your last post IS the way to go.

Imagine you keep all the IDs, Last and First names. Susie Brown gets married and changes her name from Brown to White. What do you do? A lot of code to accomodate this change.

If you keep just IDs, what do you care if she gets married (or divorced) and changes her name? The ID stays the same. ;-)

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[BradCustom]

Thanks Andy,
That is what I did! I changed the forms, queries and reports to use the First and Last from the linked SQL table.

 

[Andrzejek]

Done.
The worst 'stuff' you can do in the data base is repeat data and have it in nore than one place. it is a nightmare.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.