>Hi!
>
>Ok, let's say i got 2 tables (A & B) the second table sTores records that might become in child records of table A. My questions are: the posible child records, should be put in another table and establish a relation between table A and the new table or stay where they are and establish and a relation between both tables? In case, the second option is the right one (which I gues it is, for the updates, etc), what would happen if a child record could become in a child record for different parents? how could i deal with this?
>
>TIA
To resolve a many-to-many relationship, you need a third table.
I will switch to Spanish now.
Ejemplo: En una factura aparecen varios productos. Un producto puede aparecer en muchas facturas.
Solución: crear una tercera tabla, que en este caso representa "detalles de factura" (adicional a la tabla de facturas).
Saludos, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)