I am creating 2 tables, one which is to be our internal database which shows all our products that we have (10 columns per product). The second table is a product table to be shared with customers and be accessible through an external link. The main difference will be the second table will have reduced information that is sensitive (6 columns per product).
I would like to update table 1 acting as the main internal database, which then feeds and automatically updates the 6 columns in the external table. Is this possible?
Secondly - i believe its possible to share 1 table within a base, while keeping other tables hidden, is that correct?
Many thanks for your help