Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Lookup column

  Asked By: Ami    Date: Mar 16    Category: Sharepoint    Views: 1985

I have a problem I hope you can help me. Here is the scenario:
I have a list that keeps track of employee timesheets. I have another list that
has all the hourly rates by employee. I want to use the rates in list #2 in
list number one. I thought that using a lookup column will at least allow me to
pick the rate from list #2 but it doesn't even display the rate field, it only
display fields like ID, Version but not the field I want.

1. How can I reuse the Rate from list #2?
2. How can I get all fields to display in a lookup column?



4 Answers Found

Answer #1    Answered By: Lizette Mcconnell     Answered On: Mar 16

What column  type is "rate" and does it appear in the default view for
list #2? Lookup columns only work against certain field  types...

Answer #2    Answered By: Rosanna Parrish     Answered On: Mar 16

The column  type for the "Rate" field  is currency but I have tried with number  as
well and still cannot see it.

Answer #3    Answered By: Kalash Karmakar     Answered On: Mar 16

Try with either a "Single Line of Text" or "Calculated" type.

Answer #4    Answered By: Mauricio Tanner     Answered On: Mar 16

I tried "Calculated" but still it doesn't display. When I tried "Single line
of text" it does, but can't use it in my calculated field.

Didn't find what you were looking for? Find more on Lookup column Or get search suggestion and latest updates.