I have a set of files for a school district, a set for each campus. I want to make previous year's data from the previous campus available to the "next" campus. Even though I have related the prev campus files to the current campus files, it asks for a login because the login data is different for each campus.
How can I allow a campus to read-only data from the previous campus without requiring a password? I can't add the user login from the "next" campus to the last because they all have the same uername, just different password.
Hope I'm making sense.
I hope this is easy and I'm missing something here (but it will be humbling if so).