Help with using tables from another database

[muskee]

I have 2 databases, each created with filemaker pro 16. They are both mounted on filemaker server 16.
So it's database A and database B.
In database A I added 3 tables from database B. I made a layout with some portals in database A that show information of database B.
Whenever I try to access this layout in database A, I get the login screen asking for my credentials of database B, Is there a way to tell filemaker just to use the admin account and always show the tables from database B with all permissions? (instead of always having to do the login)

If I don't put the credentials of an account with permissions to see this data, then the portal will show a message saying " < File missing >""

Would really appreciate your help!

[Lee Smith]

Hi muskee,

Please don't use generic names for your Files, Tables, Field, Relationships, etc.., it adds confusion when trying to understand your question..

Lee

[rwoods]

Hi muskee

You need to add accounts to Database B with exactly the same username and password as you have in Database A. That way, FileMaker will try to open Database B with whatever name/password was used to open Database A and show the data without asking for login.

If there is not a matching account in database B, then you will be asked for login credentials.

There is no way to tell FileMaker to use a specific name/password when opening a file that is referenced in 'Manage -> External Data Sources', you have to do what I describe above.

[muskee]

41 minutes ago, rwoods said:

Hi muskee

You need to add accounts to Database B with exactly the same username and password as you have in Database A. That way, FileMaker will try to open Database B with whatever name/password was used to open Database A and show the data without asking for login.

If there is not a matching account in database B, then you will be asked for login credentials.

There is no way to tell FileMaker to use a specific name/password when opening a file that is referenced in 'Manage -> External Data Sources', you have to do what I describe above.

Thanks, solved!