I have an application that is used to pull in details from multiple other applications and tables and then add to that, for presentation to another group. So different data, owned and documented by different teams, in various tables. but for my needs, it makes sense to pull field contents from each into this one table I own and manage. How can I do this, without having to select it for each separate table/app?
Example: Table for Customer Info from needs assessment needs to pull in:
Basic customer data from one app somewhere else
Basic info about their current solution from another
Basic info about the potential sale to this customer from another
All could be keyed on the customer name, of course, but it won't link without selecting customer name from 3 different fields because the actual relationship is based on the numeric key fields.