How do I show an associated name based on an ID number?

[MyWaterloo]

How do I code my field, that shows an ID, to show the name associated with that ID? example: Employee ID = 1 Instead: Employee ID = Bill
Thanks

[ChipR]

Make a query with what you have already and join it with the employees table to add the name field?

[MyWaterloo]

@ChipR
That worked, Thanks! I feel kind of silly asking such a "duh" question...I thought there was a way to do this by formatting the field or something...Maybe I was thinking of a lookup table (which I know one should never do).

[missinglinq]

MyWaterloo, in the future, please give your thread a title indicative of the problem/question you have.

I can't remember how to do this.

doesn't really tell anyone anything, except that your memory is faulty!

This will not only increase your chances of receiving an appropriate answer, but will allow others who come here with similar problems to benefit from the solutions posted here.

Thanks!

Linq ;0)>

Moderator

[MyWaterloo]

@missinglinq
;-) Well at least this solves the mystery of my changing thread titles. I thought I was going crazy (which is worse than a faulty memory). I will try to be more specific when titling my threads. Sorry, I was being sloppy trying to ask questions on the fly...

[NeoPa]

@MyWaterloo
LOL.

No. Our moderators are encouraged to amend the titles where appropriate for the reasons Linq has explained. There is nowhere that this would be shown (unlike for amending a post where it can be noted).

We're happy that you'll bear that in mind in future :)