[V4RB] Valentina relations

Pedro fp lists at pedro.Net.au
Wed May 28 14:03:22 CDT 2003


G'day Folks

I'm considering breaking the database in my project out of the rather 
flat structure it's been in & am hoping for some clarification to save 
me from doing a whole lot of work & discovering it's wrong or doing 
more work than I need.

My primary table [tableA] has some meta-data fields which are always 
the same for 1 or more records so I'm thinking of breaking those out to 
tableB with an ObjectPtr field in tableA. Within tableB there are some 
fields that are always the same for 1 or more records so likewise I'd 
break those out to tableC with an OpjectPtr in tableB. The same applies 
yet again in tableC so if I went all the way I'd have a tableD.

The question is, do I need to keep ObjectPtrs to tableC & tableD in 
tableA or will the links tableB to tableC & tableC to tableD 
automatically flow through?

Cheers, Pedro :-)

Web: <http://www.pedro.net.au>                    PGP Key ID: 387CD96F
Instant messaging...  AIM: bandidoOfOz  ICQ: 27671678  Jabber: pedrofp
                       MSN: mail at pedro.net.au           Yahoo: pedro_fp
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"There are only 10 kinds of people in the world ...
those who understand binary numbers & those who don't."
                                          origin unknown




More information about the Valentina mailing list