>Hi everyone
>
>How can I "programatically" create a relation between to or more tables in a dbc ?..
>Thanks in advance.
>
>Carlos Burgos
I don't know of a way to do it, but I do all changes to table structures as follows:
Have an empty copy of the database (zero records in all tables). This is the "official structure", where all changes are done first.
Have a programm that combines this empty with the client data, doing an APPEND FROM for each table.
Some temporary directories are required. Also, RI must be disabled - or else, make sure you copy a parent table before you copy the child table.
Once you have the generic program, any changes - fields, new tables, indices, views, relations, you name it! - are done quite easily.
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)