Link back to previous entry

[Guest]

I have set up a table called TEXTUNIT with the following
fields:
TEXTID autonumber
TEXT text
PARENTTEXTID number

I need a link back to the previous entry so that I can
group text together. The text will need to be displayed
in groups so I have used PARENTTEXTID to link back to the
TEXTID of the previous TEXTUNIT in the grouping.

Is this the best way of doing this type of thing? Are
there alternative better ways? And when at the start of a
grouping is it best to set the PARENTTEXTID equal to the
TEXTID to identify the start of a group of text?

Thanks.
..

 

[Marshall Smith]

That sounds like a pretty decent way of doing that. Remember, in your
relationships screen, to set up a relationship between PARENTTEXTID and
TEXTID.

Oh, and don't have a field named TEXT. Bad, bad use of a reserved word.
:-(

When you are building your form, you can set up code to take the
PARENTTEXTID of the current record, and paste it into the PARENTTEXTID of
the new record. That will keep your group together. Similarly, when you
create a new group, you can set the PARENTTEXTID to be the same as the
TEXTID through code.

HTH,

Marshall Smith
Project Developers, Inc.

 

[Guest]

Marshall

Thanks for that feedback - very useful.

-----Original Message-----
That sounds like a pretty decent way of doing that. Remember, in your
relationships screen, to set up a relationship between PARENTTEXTID and
TEXTID.

Oh, and don't have a field named TEXT. Bad, bad use of a reserved word.
:-(

When you are building your form, you can set up code to take the
PARENTTEXTID of the current record, and paste it into the PARENTTEXTID of
the new record. That will keep your group together. Similarly, when you
create a new group, you can set the PARENTTEXTID to be the same as the
TEXTID through code.

HTH,

Marshall Smith
Project Developers, Inc.




.