Views:

Lookup Fields and Connecting Records in akoyaGO (Visual)

The following charts will give you a visual of some primary "lookup fields" in akoyaGO. Lookup fields in akoyaGO link data between two different tables and allow us to make connections throughout the database.

For example, though an organization will only have one Constituent record in akoyaGO, that Constituent record can be linked to multiple Contacts, Requests, Payments, etc.

These chart graphics show some of the first lookup fields that a new user will encounter. However, they are not all-encompassing, and there are even more lookup fields in akoyaGO. The graphic intends to give you a basic idea of how the different tables in akoyaGO can be connected.

If you use the akoyaGO with Accounting app, please reference the first graphic.
If you use the akoyaGO (no Accounting) app, please reference the second graphic.

Information About Graphics:
The orange rectangles in the charts below represent the different areas in akoyaGO.
The teal boxes in the charts below represent different tables in akoyaGO. You can find more information on the Tables of akoyaGO in this Knowledge Article.

akoyaGO with Accounting

An area (formerly known as "workplace") is a collection of tables that pertain to a certain sector of business. In akoyaGO with accounting, our primary areas are Grants Management, Donor Management, and Fund Management. GOapply and Tools are also areas available in akoyaGO with accounting. Please note that permissions for tables within the GOapply and Tools area are set by specific Security Roles.

The connections or arrows between the different tables represent lookup fields. As mentioned above, lookup fields allow us to connect two records from two different tables. Lookup fields are indicated with a magnifying glass icon:

akoyaGO (No Accounting)

An area (formerly known as "workplace") is a collection of tables that pertain to a certain sector of business. In the akoyaGO app, the primary areas are Grants Management, Tools, and GOapply. Please note that permissions for tables within the GOapply and Tools area are set by specific Security Roles.

The connections or arrows between the different tables represent lookup fields. As mentioned above, lookup fields allow us to connect two records from two different tables. Lookup fields are indicated with a magnifying glass icon:

Keywords: Lookup fields, primary contact, parent constituent, connections between tables, entities