ContributionsMost RecentMost LikesSolutionsConnecting apps togetherI have 4 different apps that are identical in terms of fields/relationships, but the information they hold are different as each of the 4 apps represents certain regions in the world. I want to make a new app that brings all this information together and gives me statistics globally. No one needs to edit the global app, I just need the global app that automatically combines the information from the same tables in the 4 different apps and brings it together in the 1 app so I can create reports on that data. Is this possible?Multiple same fields containing different informationI have an opportunities table, where a person can create a potential opportunity in the business. I also have a customer table (which is connected to a contact table, a customer can have many contacts). The opportunities and customer table has a many to many relationship, an opportunity can have many customers, and a customer can have many opportunities. In my opportunities table, I have been able to input a lookup field which allows the user to select a customer (and then a contact under that customer). However, because an opportunity can have many customers, I will need several lookup customer (and contact) fields. I have replicated the fields, and they seem to work when I am inputting information in to the form, however when I save the opportunity it is displaying all of the customer and contact fields as the same customer and contact. How can I get these lookup fields to save separate data from the customer table? Thanks, Rosie