fmpuser0

Displaying Selected Data from One Table into Another

Discussion created by fmpuser0 on Dec 4, 2018
Latest reply on Dec 6, 2018 by fmpuser0

I have two tables:

 

1. Operations Expenses

 

Date / Concept / Amount / Expense Category

 

This table is populated by importing records from a spreadsheet every month.

 

2. Financial Expenses

 

Date / Concept / Amount / Expense Category

 

This table is also populated by importing records from a different spreadsheet every month.

 

I need to bring some of the expenses that meet certain criteria on the Financial table to the Operations table.

 

I have created a unique field on the Financial table and another unique field on the Operations table, and I have linked one to the other. Then I have used the following formula on the unique field of the Operations table:

 

If ( Amount   =   "0" ; ""  ; Financial Expenses::UniqueField)

 

I was hoping that once I had this UniqueField populated with data from the Financial table I could simply fill in the rest of the data (Date-concept-amount) by pulling in the data from the Financial table.

 

But it does not work. What needs to be changed to accomplish my objective?

 

Thanks to whomever can help.

Outcomes