[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