Thanks – Dumb! I wasn’t
carrying it far enough and creating a downstream file for the pointer…./t
From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Cameron Schlehuber If your TESTFILE field .01 is a pointer to
another file, then the “DOE,JOHN” can’t be the internal value
in the .01 field. “DOE,JOHN” could be in the .01 field in the
file TESTFILE is pointing to. And, yes, you should be able to have a
unique number in field 2 be a KEY to TESTFILE. If I recall correctly just
tell FileMan when you create a new-style cross-reference on field 2 that you
want it to be a unique key. -----Original Message----- With so much excitement, I hate to post such a mundane
question as pointers and keys. However, I have never been able to get
KEYs to perform in the way I expect. I want to have file TESTFILE point to
field .01 of another file so that I can use backward pointers. Further I would
like to create a record in the file with a unique # to main the uniqueness of
multiple instances of the same name in .01 field of the file. It seems I should
be able to enter a unique # such as 12345 without having to encapsulate a new
entry as the name file in quotes. For instance if the name is
DOE,JOHN in the referenced field, I would like to enter 12346 (in field
#2) to create a unique entry, then enter DOE,JOHN in field .01, separate from
the first record than the 12345 and still allow the .01 field in this record to
exist as “DOE,JOHN” . Is this workable? Or is this just bad policy?
I know this is sort of confused and will be difficult to
sort out. Basically, I want to have field 2 as the UNIQUE ID for each record in
TESTFILE, and .01 field point to a sort of parent file. Thanks, thurman |
- RE: [Hardhats-members] Pointers and keys Thurman Pedigo
- Re: [Hardhats-members] Pointers and keys Gregory Woodhouse
- Re: [Hardhats-members] Pointers and keys Gregory Woodhouse
- RE: [Hardhats-members] Pointers and keys Thurman Pedigo