A few things to know. If you use Adapter, BO or UBAQ it will only be limited to the companies the User has access to.
You have a few options.
- You can do it via BPM (UD Table)
- UBAQ (Manual Code)
- UBAQ w/ BAQDataView (search the forums there are many BAQDataView examples)
- BO / Adapter using a Service Account to Impersonate New Session.
- Service Connect (kind of meant for cross-company updates)
- REST
Search the forums for BAQDataView, sounds a bit like that would be your canidate, because you can Bind it to a Grid if I recall.