INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Store Text Box data in a Table Field

Store Text Box data in a Table Field

(OP)
thread181-1292653: Lookup fields in a form

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!!

RE: Store Text Box data in a Table Field

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.

RE: Store Text Box data in a Table Field

(OP)
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.

RE: Store Text Box data in a Table Field

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. winky smile

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.

RE: Store Text Box data in a Table Field

(OP)
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.

RE: Store Text Box data in a Table Field

smile Done. smile
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close