I have a database with two tables. The first table (Inbound) is a list of tables and their respective data fields that are used to create Output tables. The second table (Output) is a full list of what the Output tables are (Entity Name, Table name, column names, Data Type, Attribute format, etc.). These tables are "linked" via a key so that I know which Inbound piece of information is responsible for the Output result.
I need to create a third table that we can share with others that is exactly what is in the second table, the Output table, but limits to only show a few of the fields.
The main Output table has EVERYTHING we need for a reference, but when sharing the database, I want to only show the select information for my users to see and not be bogged down or confused by the rest of the information. The main output table has about 18 fields, but I only want the "new" table to show 10 of those fields.
Is it possible to create a condensed view of an already existing table? How do I accomplish this?