Can you enter a number in one form and have i...

(Kelly VanAusdall) #1

Can you enter a number in one form and have it automatically show up in a column on another table?

In a sense be copied to the other table/column upon entry?

(Grant Stead) #2

Yes, you can do it a few different ways… You can have an “On-Save” action that basically doubles back after you save the form to run a data change action. You can also have a virtual column that displays the info, but it won’t be available in the backend.

(Kelly VanAusdall) #3

@Grant_Stead What formula would you use as the copy expression?

(Grant Stead) #4

For the virtual column? Also, is the table to table relationship intact? i.e. a REF column from the child table to the parent table. Hook me up with some table names and column names

(Kelly VanAusdall) #5

The child table name to enter the form is Weight Record. The column is Weight Entry. The parent table is Pigs, the column for the copied number to go in is Current Weight. Pig name is the ref column.

In Weight Record table, Entry ID is the key column & in the Pigs table Pig name is the key.

Whichever is the best so that when viewing pig details you can see the number that represents Current Weight is what I’m looking for.

(Kelly VanAusdall) #6

And it has to apply to the certain matching Pig Name.

(Kelly VanAusdall) #7

@Grant_Stead thanks for your help. See my above reply

(Grant Stead) #8

@Kelly_VanAusdall it sounds like you’re looking for a standard select formula… So, in the parent table you want the “most recent” weigh in… So create a virtual column… With a maxrow formula…

So… Take a look at this article… You should be able to find the maxrow of the weigh-in table where the [pigname]=[_THISROW] then derefference into that for the current weight…

See if you can make sense of all that. If you need a little more help, just post back! Good luck! - List Expressions and Aggregates List Expressions and Aggregates

(Manoj Kawathe) #9

How to roundup my photos