VStudio - Can I make RecID my Primary Key?

[Barry G. Sumpter]

Acknowledged!

Still climbing the steep learning curve.
Language, Concepts, and tools.

Can I get away with using BinaryLinks on 1:m relationships on a small
database?





-----Original Message-----
From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Ruslan
Zasukhin
Sent: Friday, 1 June 2007 11:29 PM
To: valentina-studio at lists.macserve.net; valentina at lists.macserve.net
Subject: Re: VStudio - Can I make RecID my Primary Key?

On 1/6/07 10:41 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

>> What links PK and FK?
>> 
>> RECORDS.
>> 
>> BinaryLinks also linking RECORDS of 2 tables.

> Well for me, that's not how I see it.

START change your mind !!! :-)

I am seriously  

> I see the practical link as the field values.
> I see the generic broader definition of a link
> as a field in one table linking to a field in another table.

You describe here old good Foreign Key.

We offer NEW point of view.
Try understand it.

 
> I don't see the RECORDS linking together, i.e. without the fields and
> practical link of field values.

Does in REAL WORLD exists any fields ???????????

Exists Person, and exist Phone.
    and exists LINK between Peter and phone 22222

HOW you describe this link -- is 10th question.

You are used to "links by VALUES" from relational model.

So what?! This is not single way and not the best

 
> Specifically, I see it as the RecID field (value) in one table
> linking to a RecID field (value) in another table
> is what makes the BinaryLink work.
> 
> More specifically, you can set up the link but without the data in the
> fields there is no actual link.
> I could set up the link but didn't understand how to actually link or use
> the link.
> 
> Anyway, don't want to get tied down to these concepts when daylights a
> waisin.

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


_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio