Link back to previous entry

[Guest]

Hi

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.

 

[tom]

Sounds like you need 2 tables, with a one-to-many relationship...

Tom.