I have an application called Common Lists that contains multiple forms populated with common data for an organization (e.g. Employees, Departments, Accounts, etc.). I want to build a suite of applications that share the common data in the Common Lists application.

For example, the Purchase Manager application has a form called  Requisitions. After the user inputs the value for Department, we need to retrieve the value in the field "Purchase Approver" that is in the Department form of the Common Lists application). My understanding is that the Common Lists application needs to include a function that can be called from the Purchase Manager application. Is this correct? If so, I'd appreciate guidance with sample code.

Thanks,

Mark