Importing Data and RecID

[Ruslan Zasukhin]

On 9/2/09 11:01 AM, "Barry G. Sumpter" <barrysum at bigpond.net.au> wrote:

Hi Barry,

> LOL.  Good luck following that.

> With Primary keys and foreign keys you can see the value of the link.
> Primary key of State: Vic  you could see a foreign key of Vic
> Vic representing the state of Victoria
> 
> With Valentina just forget about using Primary and Foreign key.
> 
> Just use the RecID links instead.
> 
> A quick sql example is:
> Link Record (27) of tblPersonnel with Each Record (8) of tblStates
> 27 is the RecID of a Personnel record say Barry
> And 8 is the RecID of a States record in this case Victoria
> 
> There is an unlink as well and some pretty cool ways of defining the Record
> clause.
> 
> Again don't waste your time with the other types of links.



******
> You can also setup multiple links say for a sales man who services different
> states.
> 
> And as far as I know you have to use the additional LINK sql command to link
> records.

This is required only for BinaryLinks.

For ObjectPtr - RecID pair, you just assign value into ObjectPtr field,
Exactly as with FK field in RDBMS.

 
> I'd like to know if there is a way of linking records using Valentina
> studio.

Yes.

In Table Editor, for 2 tables linked by some LINK,
You will see 2 panes, Top and Bottom.

Select record in T1 pane by checkmark - first column - mouse click.
Then just do mouse click into check mark column of bottom pane to link
records.  Or unlink them.

>      NOT the sql builder but the visual link window.

> i.e. check mark this record in that table
>             then check mark the records in the other table
>                now click "Link" button

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