Re: How do I create a Look Up List based on a Calculated Type Field by CW
CW
Wed Aug 16 08:19:29 CDT 2006
Excellent question Maurice, I've been frustrated with the same issue as
well.
ps: I know this is not a help, just letting you know you're not alone.
CW
Maurice Brouwers wrote:
> OK, I understand: calculated fields are calculated at the end of an
> input or update. But when you create a lookup list, the field is
> already calculated when you did the input or update. So the data should
> be available when looking up in another list.
>
> It also looks like you can't create lookup field from the following
> types: lookup, choice and date.
>
>
> Engelbert schreef:
>
> > It's because of the order in which things are done. Calculated fields are
> > calculated at the end so you can't base other fields on them.
> >
> > I can't find a FAQ or other reference exactly on LookUp and Calculated but
> > I'm fairly certain the above is the reason.
> >
> > Engelbert
> >
> > "Maurice Brouwers" <mauricebrouwers@planet.nl> wrote in message
> > news:1155558421.024777.161640@h48g2000cwc.googlegroups.com...
> > >I created an EMPLOYEE list with a FULL NAME field based on =[FIRST
> > > NAME]&" "&[LAST NAME].
> > >
> > > I also created a VACATION list. I tried to create "lookup" column based
> > > on the EMPLOYEE - FULL NAME column. A bunch of other fields in the
> > > EMPLOYEE table are visible as possible "lookup" columns, but the FULL
> > > NAME column is not.
> > >
> > > Are calculated fields not valid for Look Up type columns? And if so,
> > > are there types not valid?
> > >