Sage 100

Customer wants views created in SQL that match certain work tables. I can get the list of work table fields and intuitivley know where they come from, but, is there a way to tell for certain where each work table field is sourced from?

TIA

If you act like you're creating a UDF in a wrk file, you can hit the Data Source dropdown to see the applicable files:

You could avoid recreating the work table by filling it using BOI or UDS scripts. This works with either SQL Server (Premium) or ProvideX Work tables. But, because work tables are serially usable and have the potential, although rare, that more than one user could fill them using different parameters simultaneously. This technique has the advantage to make use of saved report options, settings, and selections. I also use this technique with Excel VBA and Power Query so that an arrangement of the work table (and optionally fields from other linked tables) loads directly to an Excel table for use in summary reports including Pivot Tables and Power Pivot.

@Dan Burleson SQL admin is requiring a view for security.

@Brett Zimmerman Great idea - thanks.