Hello All, We are working on archiving strategy. In that process, to make the DB Script automated but not hard coded, trying to figure out a SQL query to find list of all the fields and the forms exists in JOIN forms.
Trying something like below: select queryshort from schema_join where schemaid=3128 result: 4\1\99\536870913\1\1\ >From the example above, (Column/field)536870913 from Form A is joined with (Column/Field)1 from Form B. Wanted to check with DB Experts in here to figure out a query to find joined columns/fields, tables/forms we have in JOINED forms on our system. We have over 100 JOIN forms, so thought Query would be way faster than manually opening each form and identifying the forms and fields. Please advise. Regards, Raj _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
