One Pointer Field Fits All

[Ruslan Zasukhin]

On 5/29/05 4:22 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:

> Another question.
> 
> I have a table I refer to as Notes. I would like that table to be
> used to hold ALL notes in a given RB project. This, no matter, what
> other table those notes might belong to.
> 
> Is there a technique to have one field act as the differentiator as
> to which table the notes will appear in? Something along the lines of
> a field in Notes to identify the other table a given note belongs to
> and the pointer field to identify the record in that other table the
> note is associated with?
> 
> This was easily accomplished in FileMaker. Just set up the link in
> the table that the note was supposed to be related too in Notes.

So this is easy?  
I.e. If you have 10 tables around, you need make 10 links?

> How  
> can that be done in V4RB? I'd like to avoid having to put a separate
> pointer field in Notes for every other table that would require an
> ability to have Notes associated with it.

Pointer field must be in each of this 10 tables,
I.e. You get the same 10 links

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]