ContributionsMost RecentMost LikesSolutionsRe: unrelated relationshipsMike you are right. A simple loop would make life easier. While I'll have only one record with that matches an event, there are multiple possible values that have to be evaluated to extract the right date. Right now the max is 10 so thinking I can build for 30 for today. I can easily part our the original mutli-text into individual values but how do I loop through to evaluate each one to get match the right one? Any recommendations on how you did this? ------------------------------ David Berndt ------------------------------ Re: unrelated relationshipsI played with that but when I bring it back down it is a textlist instead of text and I couldn't seem to parse it. Is there a way to convert it/parse it when it is that type? ------------------------------ David Berndt ------------------------------ Re: unrelated relationshipsIt is a particular one. As the site authorization is also tied to the provider, each provider would only only have 1 authorization per study training/site combination and only one provider is associated with a particular event. ------------------------------ David Berndt ------------------------------ unrelated relationshipsIn our app we have the primary set of tables and then some that I would call "supporting" tables. The issue is at the lowest level, I may have all the necessary data to build a relationship but it doesn't really exist all the way to the top so I can ensure I'm matching the right records. Here I go to try to explain it a bit The Site Authorization has the Provider, Study and Site and this Auth Date The Event has the Study, Site, and Provider and the Event Date We need to develop a report at the event level that provides the number of days between the Authorization Date and the Event Date. I cannot see how to build the relationships that can get Auth date up the chain and back down to the Event table. A "join" would be pretty simple but since that isn't an option - any suggestions? ------------------------------ David Berndt ------------------------------ Re: Audit Trail Searchis there a different method to access the data? ------------------------------ David Berndt ------------------------------ Re: Audit Trail Search Image isn't working but the only search options I see are: Start date, end date, app name, user email or logid The data exists but short of exporting all the records how do I search for the record id in the audit log? ------------------------------ David Berndt ------------------------------ Re: Audit Trail SearchI have a specific record that we need to assess both who accessed it and who made changes. So I know the specific record ID but as I see it I cannot search using that element. So I have to search for all records for a week and a time and then export. ------------------------------ David Berndt ------------------------------ Audit Trail SearchIs there anyway to search for specific record id? If not, strongly recommend it. Having to do an analysis on a record due is really challenging when you have export all the data for 7 days at a time. ------------------------------ David Berndt ------------------------------ SSO with Azure/O365Has anyone implemented SSO using Azure for your provider? Any gotchas or recommendations? ------------------------------ David Berndt ------------------------------ Re: Forecast vs actual by monthsIt feels like these are workarounds and duplicate jobs to protect the workarounds. Sometimes I just really would like to be able to run a simple query to create the reports. Any other options? ------------------------------ David Berndt ------------------------------