I could use some advice with how to share/structure my app with another department agency where we would share only one table, the ClientTbl, which is the parent to all other tables. I’ve built a very simple app for my department for completing detention assessments on Juveniles who’ve been arrested. My app only has a few tables, ClientTbl, DetentionScreenTbl, DetentionHearingTbl, and UserTbl. My app is working great and is proving to be very helpful. I’d like to allow another county to also use the app as well, but they use a different detention screening instrument, i.e. DetentionScreenTbl so I cannot simple allow them to use the app as is, I will need to build a DetentionScreenTbl specific to them. It is possible that from time to time that we are screening the same Juveniles, just at different times, so I’d like for both agencies to be working from the same ClientTbl. My thought is to simply build a second app, add the ClientTbl from my currently working app, and then just build out this second app as I did mine. This was we’d all be working from the same list of clients, but the users would not be able to see another counties detention assessments and detention hearings. I’m thinking that this may cause issues with my unique ID’s that are currently in place in the ClientTbl as these only exist in the app and not the spreadsheet.
Thank you in advance for your advice and suggestions!