Chrism Posted June 27, 2023 Share Posted June 27, 2023 Hi, trying to see if this will work the way I need. Database 1, restricted to only to User 1 and User 2 has no access. Hosted on Filemaker server Database 2, User 2 allowed access and also hosted same Filemaker Server. But this database pulls data via relationships from Database 1. User 2 can open Database 2 ok, but it still asks them to authenticate to Database 1 as well? Anyway it can not need to do this and still have the relationships intact? Thanks Link to comment Share on other sites More sharing options...
bcooney Posted June 28, 2023 Share Posted June 28, 2023 No. Link to comment Share on other sites More sharing options...
Chrism Posted July 19, 2023 Author Share Posted July 19, 2023 Thanks! Link to comment Share on other sites More sharing options...
rwoods Posted July 19, 2023 Share Posted July 19, 2023 Hi Chris To solve this you will add that user to Database 1, but you could restrict their access in 'Security' so that they can't view any layouts. So long as that user in Database 1 has access to the tables that you need them to see the pulled data from, then Database 2 will be able to access what is needed. You can even set it so that they cannot edit data in any tables if that is what you require. More or less anything is possible, but as it can be complicated, you should definitely test that it does what you are expecting! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now