>We have a DBC which contains a table with validations. Our application clones this table, the result of which is used for dataentry. We need to have multiple clones with unique names which possess the same validations as the original table.
>
>When we create the new table, we create the backlink. My question is this: Are we limited to only 1 active link to a table with the same validations?
>
>After opening one table with the backlink, if I subsequently open another table (of the same clone type) I need to backlink that one as well - even if it is the original table.
>
>Thanks much,
>Nancy
You are linking these clones to the DBC? Then, when finished, are the clones deleted/removed from the DBC? Why not just create a single updatable sql view of the table and use private datasessions? This allows you to have multiple instances of the sql view open in the same VFP session without having to track temp file names, etc. A sql view honors validations, and has all the advantages you may be desiring in your cloned tables. If necessary, views can be opened with no data. The view can be parameterized to select a specific set of records. You can take advantage of the View Designer to create this. A code example with a parameter [e.g., ?lcValue]:
create sql view myview as select <i>field_list</i> from mytable ;
where somefield like ?lcValue order by ...
You would pass the parameter [lcValue] as something like "Smi%" to retrieve all records whose fieldname starts with
Smi.
Mark McCasland
Midlothian, TX USA