This content has been marked as final. Show 4 replies
Is there a preferred approach to doing this? I have a couple of ideas, but I'm not sure what would be the most flexible/easiest to implement method,
1. 3rd party process to load a SQL table. The data would not be real time, but once we have it, we can filter it anyway we want.
2. Linked table in access. That will require some additional programming, but that would be real time.
3. Extensions and API call? Not too sure how this would work. It'd be real time, but I don't believe we'd be able to filter like we would with traditionally loaded data.
Any feedback would be appreciated.