Hello.  I am using FM 6.0 v 4 on a PC (Win 2000 Pro).  I am having a
problem with a value list.

There are 2 files involved, Tutors and Courses.  When entering details
of a course, the user needs to assign a tutor to that course, which is
where I'm using the value list.

The relevant fields in the Tutors file are t_id, t_surname,
t_forename, and t_full_name.  In case it's relevant, t_full_name is
calculated as:
Trim(t_forename)  & " "  & Trim(t_surname).

In the Courses file, I have a field called c_t_id.  
The relationship between the files is defined (in Courses) as
c_t_id=::t_id.
The field format of the c_t_id field is "Pop-up list using value list
tutors".
The "tutors" value list is defined as:
Fields: "t_id" and "t_full_name", File: "tutors".

Now for the problem.  When testing this, I had one tutor, whose ID was
39, and full name was Bob Iles.  Worked fine.  I then imported the
real data from Access (via Excel), opting to replace existing records.
 The import seemed to work fine, giving me 65 new records in the
Tutors file.  But the "tutors" value list in the Courses layout
continues to show Bob Iles as tutor no. 39, when in fact on the Tutors
*file* no. 39 is no longer Bob Iles, but Linny Josham.  The only way I
can get Linny Josham to appear in the value list is:
1. Change the tutor to something completely different, 
2. Pull up the value list again,
3. Select Tutor 39 (shown as Bob Iles).  When I actually click on
tutor 39 to select it, it *briefly* shows Linny Josham, but then
reverts to Bob Iles when I release the mouse click.

So, I really need to know where I'm going wrong, either in my use of
relationships or value lists.  It's probably something really basic,
which I need to understand at this early stage of my use of FM.

Any help would, as ever, be much appreciated.

Dave Hobson.

Dave,

How is the t_full_name calculation stored? It might just be that you
calculation is not updated because you did not actually change anything in
the tutors file. In that case change the calculation to "unstored" and see
what happens.

W.
"Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
news:b71b0b4.0311250232.3850ae6@posting.google.com...
> Hello.  I am using FM 6.0 v 4 on a PC (Win 2000 Pro).  I am having a
> problem with a value list.
>
> There are 2 files involved, Tutors and Courses.  When entering details
> of a course, the user needs to assign a tutor to that course, which is
> where I'm using the value list.
>
> The relevant fields in the Tutors file are t_id, t_surname,
> t_forename, and t_full_name.  In case it's relevant, t_full_name is
> calculated as:
> Trim(t_forename)  & " "  & Trim(t_surname).
>
> In the Courses file, I have a field called c_t_id.
> The relationship between the files is defined (in Courses) as
> c_t_id=::t_id.
> The field format of the c_t_id field is "Pop-up list using value list
> tutors".
> The "tutors" value list is defined as:
> Fields: "t_id" and "t_full_name", File: "tutors".
>
> Now for the problem.  When testing this, I had one tutor, whose ID was
> 39, and full name was Bob Iles.  Worked fine.  I then imported the
> real data from Access (via Excel), opting to replace existing records.
>  The import seemed to work fine, giving me 65 new records in the
> Tutors file.  But the "tutors" value list in the Courses layout
> continues to show Bob Iles as tutor no. 39, when in fact on the Tutors
> *file* no. 39 is no longer Bob Iles, but Linny Josham.  The only way I
> can get Linny Josham to appear in the value list is:
> 1. Change the tutor to something completely different,
> 2. Pull up the value list again,
> 3. Select Tutor 39 (shown as Bob Iles).  When I actually click on
> tutor 39 to select it, it *briefly* shows Linny Josham, but then
> reverts to Bob Iles when I release the mouse click.
>
> So, I really need to know where I'm going wrong, either in my use of
> relationships or value lists.  It's probably something really basic,
> which I need to understand at this early stage of my use of FM.
>
> Any help would, as ever, be much appreciated.
>
> Dave Hobson.

Wouter,

Thanks for the response.  I tried your suggestion but it made no difference.
However, you put me on the right track and I have now resolved my problem -
although it still leaves me with a couple of queries.  It turns out that my
import from Excel *added* the new records, rather than replacing, so I ended
up with two tutors with the ID of 39.  (I didn't spot this originally
because the *old* record was not part of the Found Set when I viewed the
Tutors file - I don't know why).

Although I feel very certain that I'd opted to *replace* records in the
import, I must have got that wrong.  But the other worry I have is that the
import effectively created a duplicate value in the t_id field, when it's
specified as unique.  Any ideas how this happened, and how to prevent it
happening in future?

Thanks again,

Dave.

"Wouter" <wouterNOSPAM.moerdijk@planet.nl.REMOVE> wrote in message
news:bpvq4v$leg$1@reader11.wxs.nl...
> Dave,
>
> How is the t_full_name calculation stored? It might just be that you
> calculation is not updated because you did not actually change anything in
> the tutors file. In that case change the calculation to "unstored" and see
> what happens.
>
> W.
> "Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
> news:b71b0b4.0311250232.3850ae6@posting.google.com...
> > Hello.  I am using FM 6.0 v 4 on a PC (Win 2000 Pro).  I am having a
> > problem with a value list.
> >
> > There are 2 files involved, Tutors and Courses.  When entering details
> > of a course, the user needs to assign a tutor to that course, which is
> > where I'm using the value list.
> >
> > The relevant fields in the Tutors file are t_id, t_surname,
> > t_forename, and t_full_name.  In case it's relevant, t_full_name is
> > calculated as:
> > Trim(t_forename)  & " "  & Trim(t_surname).
> >
> > In the Courses file, I have a field called c_t_id.
> > The relationship between the files is defined (in Courses) as
> > c_t_id=::t_id.
> > The field format of the c_t_id field is "Pop-up list using value list
> > tutors".
> > The "tutors" value list is defined as:
> > Fields: "t_id" and "t_full_name", File: "tutors".
> >
> > Now for the problem.  When testing this, I had one tutor, whose ID was
> > 39, and full name was Bob Iles.  Worked fine.  I then imported the
> > real data from Access (via Excel), opting to replace existing records.
> >  The import seemed to work fine, giving me 65 new records in the
> > Tutors file.  But the "tutors" value list in the Courses layout
> > continues to show Bob Iles as tutor no. 39, when in fact on the Tutors
> > *file* no. 39 is no longer Bob Iles, but Linny Josham.  The only way I
> > can get Linny Josham to appear in the value list is:
> > 1. Change the tutor to something completely different,
> > 2. Pull up the value list again,
> > 3. Select Tutor 39 (shown as Bob Iles).  When I actually click on
> > tutor 39 to select it, it *briefly* shows Linny Josham, but then
> > reverts to Bob Iles when I release the mouse click.
> >
> > So, I really need to know where I'm going wrong, either in my use of
> > relationships or value lists.  It's probably something really basic,
> > which I need to understand at this early stage of my use of FM.
> >
> > Any help would, as ever, be much appreciated.
> >
> > Dave Hobson.
>
>

Dave,

During import did you also specify the "match field". That is a step thast
is easy to overlook. If you set this up right it will not import the
duplicate keys. Unfortunately FM does not check field validations during
import. If you need to validate more you will have to script it.

W.

"Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
news:meLwb.9796$K%5.9769@news-binary.blueyonder.co.uk...
> Wouter,
>
> Thanks for the response.  I tried your suggestion but it made no
difference.
> However, you put me on the right track and I have now resolved my
problem -
> although it still leaves me with a couple of queries.  It turns out that
my
> import from Excel *added* the new records, rather than replacing, so I
ended
> up with two tutors with the ID of 39.  (I didn't spot this originally
> because the *old* record was not part of the Found Set when I viewed the
> Tutors file - I don't know why).
>
> Although I feel very certain that I'd opted to *replace* records in the
> import, I must have got that wrong.  But the other worry I have is that
the
> import effectively created a duplicate value in the t_id field, when it's
> specified as unique.  Any ideas how this happened, and how to prevent it
> happening in future?
>
> Thanks again,
>
> Dave.
>
> "Wouter" <wouterNOSPAM.moerdijk@planet.nl.REMOVE> wrote in message
> news:bpvq4v$leg$1@reader11.wxs.nl...
> > Dave,
> >
> > How is the t_full_name calculation stored? It might just be that you
> > calculation is not updated because you did not actually change anything
in
> > the tutors file. In that case change the calculation to "unstored" and
see
> > what happens.
> >
> > W.
> > "Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
> > news:b71b0b4.0311250232.3850ae6@posting.google.com...
> > > Hello.  I am using FM 6.0 v 4 on a PC (Win 2000 Pro).  I am having a
> > > problem with a value list.
> > >
> > > There are 2 files involved, Tutors and Courses.  When entering details
> > > of a course, the user needs to assign a tutor to that course, which is
> > > where I'm using the value list.
> > >
> > > The relevant fields in the Tutors file are t_id, t_surname,
> > > t_forename, and t_full_name.  In case it's relevant, t_full_name is
> > > calculated as:
> > > Trim(t_forename)  & " "  & Trim(t_surname).
> > >
> > > In the Courses file, I have a field called c_t_id.
> > > The relationship between the files is defined (in Courses) as
> > > c_t_id=::t_id.
> > > The field format of the c_t_id field is "Pop-up list using value list
> > > tutors".
> > > The "tutors" value list is defined as:
> > > Fields: "t_id" and "t_full_name", File: "tutors".
> > >
> > > Now for the problem.  When testing this, I had one tutor, whose ID was
> > > 39, and full name was Bob Iles.  Worked fine.  I then imported the
> > > real data from Access (via Excel), opting to replace existing records.
> > >  The import seemed to work fine, giving me 65 new records in the
> > > Tutors file.  But the "tutors" value list in the Courses layout
> > > continues to show Bob Iles as tutor no. 39, when in fact on the Tutors
> > > *file* no. 39 is no longer Bob Iles, but Linny Josham.  The only way I
> > > can get Linny Josham to appear in the value list is:
> > > 1. Change the tutor to something completely different,
> > > 2. Pull up the value list again,
> > > 3. Select Tutor 39 (shown as Bob Iles).  When I actually click on
> > > tutor 39 to select it, it *briefly* shows Linny Josham, but then
> > > reverts to Bob Iles when I release the mouse click.
> > >
> > > So, I really need to know where I'm going wrong, either in my use of
> > > relationships or value lists.  It's probably something really basic,
> > > which I need to understand at this early stage of my use of FM.
> > >
> > > Any help would, as ever, be much appreciated.
> > >
> > > Dave Hobson.
> >
> >
>
>

That'll be it then!  Thanks again for your help, Wouter.

Dave.

"Wouter" <wouterNOSPAM.moerdijk@planet.nl.REMOVE> wrote in message
news:bq1qo7$chm$1@reader11.wxs.nl...
> Dave,
>
> During import did you also specify the "match field". That is a step thast
> is easy to overlook. If you set this up right it will not import the
> duplicate keys. Unfortunately FM does not check field validations during
> import. If you need to validate more you will have to script it.
>
> W.
>
> "Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
> news:meLwb.9796$K%5.9769@news-binary.blueyonder.co.uk...
> > Wouter,
> >
> > Thanks for the response.  I tried your suggestion but it made no
> difference.
> > However, you put me on the right track and I have now resolved my
> problem -
> > although it still leaves me with a couple of queries.  It turns out that
> my
> > import from Excel *added* the new records, rather than replacing, so I
> ended
> > up with two tutors with the ID of 39.  (I didn't spot this originally
> > because the *old* record was not part of the Found Set when I viewed the
> > Tutors file - I don't know why).
> >
> > Although I feel very certain that I'd opted to *replace* records in the
> > import, I must have got that wrong.  But the other worry I have is that
> the
> > import effectively created a duplicate value in the t_id field, when
it's
> > specified as unique.  Any ideas how this happened, and how to prevent it
> > happening in future?
> >
> > Thanks again,
> >
> > Dave.
> >
> > "Wouter" <wouterNOSPAM.moerdijk@planet.nl.REMOVE> wrote in message
> > news:bpvq4v$leg$1@reader11.wxs.nl...
> > > Dave,
> > >
> > > How is the t_full_name calculation stored? It might just be that you
> > > calculation is not updated because you did not actually change
anything
> in
> > > the tutors file. In that case change the calculation to "unstored" and
> see
> > > what happens.
> > >
> > > W.
> > > "Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
> > > news:b71b0b4.0311250232.3850ae6@posting.google.com...
> > > > Hello.  I am using FM 6.0 v 4 on a PC (Win 2000 Pro).  I am having a
> > > > problem with a value list.
> > > >
> > > > There are 2 files involved, Tutors and Courses.  When entering
details
> > > > of a course, the user needs to assign a tutor to that course, which
is
> > > > where I'm using the value list.
> > > >
> > > > The relevant fields in the Tutors file are t_id, t_surname,
> > > > t_forename, and t_full_name.  In case it's relevant, t_full_name is
> > > > calculated as:
> > > > Trim(t_forename)  & " "  & Trim(t_surname).
> > > >
> > > > In the Courses file, I have a field called c_t_id.
> > > > The relationship between the files is defined (in Courses) as
> > > > c_t_id=::t_id.
> > > > The field format of the c_t_id field is "Pop-up list using value
list
> > > > tutors".
> > > > The "tutors" value list is defined as:
> > > > Fields: "t_id" and "t_full_name", File: "tutors".
> > > >
> > > > Now for the problem.  When testing this, I had one tutor, whose ID
was
> > > > 39, and full name was Bob Iles.  Worked fine.  I then imported the
> > > > real data from Access (via Excel), opting to replace existing
records.
> > > >  The import seemed to work fine, giving me 65 new records in the
> > > > Tutors file.  But the "tutors" value list in the Courses layout
> > > > continues to show Bob Iles as tutor no. 39, when in fact on the
Tutors
> > > > *file* no. 39 is no longer Bob Iles, but Linny Josham.  The only way
I
> > > > can get Linny Josham to appear in the value list is:
> > > > 1. Change the tutor to something completely different,
> > > > 2. Pull up the value list again,
> > > > 3. Select Tutor 39 (shown as Bob Iles).  When I actually click on
> > > > tutor 39 to select it, it *briefly* shows Linny Josham, but then
> > > > reverts to Bob Iles when I release the mouse click.
> > > >
> > > > So, I really need to know where I'm going wrong, either in my use of
> > > > relationships or value lists.  It's probably something really basic,
> > > > which I need to understand at this early stage of my use of FM.
> > > >
> > > > Any help would, as ever, be much appreciated.
> > > >
> > > > Dave Hobson.
> > >
> > >
> >
> >
>
>

That'll be it then!  Thanks again for your help Wouter.

Dave.


"Wouter" <wouterNOSPAM.moerdijk@planet.nl.REMOVE> wrote in message news:<bq1qo7$chm$1@reader11.wxs.nl>...
> Dave,
> 
> During import did you also specify the "match field". That is a step thast
> is easy to overlook. If you set this up right it will not import the
> duplicate keys. Unfortunately FM does not check field validations during
> import. If you need to validate more you will have to script it.
> 
> W.
> 
> "Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
> news:meLwb.9796$K%5.9769@news-binary.blueyonder.co.uk...
> > Wouter,
> >
> > Thanks for the response.  I tried your suggestion but it made no
>  difference.
> > However, you put me on the right track and I have now resolved my
>  problem -
> > although it still leaves me with a couple of queries.  It turns out that
>  my
> > import from Excel *added* the new records, rather than replacing, so I
>  ended
> > up with two tutors with the ID of 39.  (I didn't spot this originally
> > because the *old* record was not part of the Found Set when I viewed the
> > Tutors file - I don't know why).
> >
> > Although I feel very certain that I'd opted to *replace* records in the
> > import, I must have got that wrong.  But the other worry I have is that
>  the
> > import effectively created a duplicate value in the t_id field, when it's
> > specified as unique.  Any ideas how this happened, and how to prevent it
> > happening in future?
> >
> > Thanks again,
> >
> > Dave.
> >
> > "Wouter" <wouterNOSPAM.moerdijk@planet.nl.REMOVE> wrote in message
> > news:bpvq4v$leg$1@reader11.wxs.nl...
> > > Dave,
> > >
> > > How is the t_full_name calculation stored? It might just be that you
> > > calculation is not updated because you did not actually change anything
>  in
> > > the tutors file. In that case change the calculation to "unstored" and
>  see
> > > what happens.
> > >
> > > W.
> > > "Dave Hobson" <dave_hobson99@yahoo.co.uk> wrote in message
> > > news:b71b0b4.0311250232.3850ae6@posting.google.com...
> > > > Hello.  I am using FM 6.0 v 4 on a PC (Win 2000 Pro).  I am having a
> > > > problem with a value list.
> > > >
> > > > There are 2 files involved, Tutors and Courses.  When entering details
> > > > of a course, the user needs to assign a tutor to that course, which is
> > > > where I'm using the value list.
> > > >
> > > > The relevant fields in the Tutors file are t_id, t_surname,
> > > > t_forename, and t_full_name.  In case it's relevant, t_full_name is
> > > > calculated as:
> > > > Trim(t_forename)  & " "  & Trim(t_surname).
> > > >
> > > > In the Courses file, I have a field called c_t_id.
> > > > The relationship between the files is defined (in Courses) as
> > > > c_t_id=::t_id.
> > > > The field format of the c_t_id field is "Pop-up list using value list
> > > > tutors".
> > > > The "tutors" value list is defined as:
> > > > Fields: "t_id" and "t_full_name", File: "tutors".
> > > >
> > > > Now for the problem.  When testing this, I had one tutor, whose ID was
> > > > 39, and full name was Bob Iles.  Worked fine.  I then imported the
> > > > real data from Access (via Excel), opting to replace existing records.
> > > >  The import seemed to work fine, giving me 65 new records in the
> > > > Tutors file.  But the "tutors" value list in the Courses layout
> > > > continues to show Bob Iles as tutor no. 39, when in fact on the Tutors
> > > > *file* no. 39 is no longer Bob Iles, but Linny Josham.  The only way I
> > > > can get Linny Josham to appear in the value list is:
> > > > 1. Change the tutor to something completely different,
> > > > 2. Pull up the value list again,
> > > > 3. Select Tutor 39 (shown as Bob Iles).  When I actually click on
> > > > tutor 39 to select it, it *briefly* shows Linny Josham, but then
> > > > reverts to Bob Iles when I release the mouse click.
> > > >
> > > > So, I really need to know where I'm going wrong, either in my use of
> > > > relationships or value lists.  It's probably something really basic,
> > > > which I need to understand at this early stage of my use of FM.
> > > >
> > > > Any help would, as ever, be much appreciated.
> > > >
> > > > Dave Hobson.
> > >
> > >
> >
> >