I have a Parent table (ie. Table1) with about 20 Child tables (Table1a, Table1b, Table1c, Table1d,…etc) linked through the PrimaryKey (UID).
The main grid shows the list from Table1 then below I have embeded grids from child tables.
What is the best practice to create global search on Parent/Child tables. It seems like creating aVIEW would work, but I have never done any Views in SC. Are there any examples ?
Arthur