Need help with linking 2 DB's
I need assistance figuring out the best solution to this challenge- I have created a db of our customers products that has 2 layouts, one with a "form view" visual jpg of the product, the other a "list view" that has product#, date fileds, description, etc. with some of our company internal info. This is shared using IWP internally. We want one of the customers (cust. A) to be able to view just their products & not the other customers products plus not be able to view the "list view" layout.
Is this possible? Or will I have to copy the db & re-configure the fields to only show cust. A's products, & share it with IWP? Is there a way to link or establish a relationship between 2 db's so I wouldn't have to enter all the data 2x?
Any & all help appreciated.
If your users enter a password in order to access the database, you can use access privileges to control which records and which layouts a user can access.
For details on this process, see Editing record access privileges in FileMaker help and pay close attention to the section labeled "Entering a formula for limiting access on a record-by-record basis".