[V4MD] help for check field values and link more tables

[Ruslan Zasukhin]

On 9/28/05 9:15 AM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> 2. More big question
> In the previous example I think that it is better create a third linked
> table... I need to add the date of registration for every Student-Course also:
> in this case I need in your big suggestion for understand the better way to
> make it. 
> 
> In my project I have all Students into a T1 with a CodeID that identifying all
> persons of the school (eg. Students = 1, Teachers = 2 and so on). I'm tryng
> with API and binary link, but it's not simple to find right values from all
> three tables as: T3 linked to T1 and T3 linked at T2.
> I hope in a example... the better way for understand Valentina :-)
> 
> T1
> Person   CodeID
> ------------------------
> Smith       1    
> Brown      1
> Cher        2
> ...
> 
> T2
> Courses
> ------------
> Math 
> Music
> ...
> 
> T3
> Date of registration
> ----------------------------
> How is better to insert this?
> 
> eg If I will find all Students that have registration to Math in 26-09-2005
> date?

In this case you cannot use Binary link, because you need to have additional
fields in the Link-Table.

So you need to use old way: third Table
    
    
t3:  PersonPtr, CoursPtr, RegistrationDate



-- 
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]