[V4MD] Howto: Linking a One Field Table to Multiple Tables

[Ruslan Zasukhin]

on 4/28/03 6:06 PM, Ray Hausmann at hausmann at reiter.com wrote:

> hi friends,
> 
> 
> in a complex database design for a learning environment
> i want to link a field to multiple tables:
> 
> 
> I have a table "Interactions" that stores the sequence
> of tasks a user has to solve.
> 
> Table: Interactions
> Field: Interactions
> 
> 
> 
> the tasks are of different type. so they have a different
> count and different types of parameters. so all parameters
> of the same types interactions are stored in one table. a
> record of one of these tables shell be linked to the above
> table. For instance ...
> 
> Table: SingleChoice
> Fields: Pos1Word, Pos2Word, Pos3Word, Pos4Word, CorrectWord
> 
> Table: TrueFalse
> Fields: TrueWords, FalseWords
> 
> ...
> 
> 
> 
> How can I achieve that table "Interactions" contains links to
> "SingleChoice" and "TrueFalse". IMO this cannot be done using
> the objectptr type for field "Interactions", am i right?

Yes, ObjectPtr cannot do this.

You need use regular RDB link. I.e. Add field Interactions into each tables
of tasks. As result you get "link by value" between tables.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------