Use a value from a related table not saved yet

[simone_checchin]

Hi to all,
I have a Table "A" with data and a table "B" related to table "A".
When I open a form to enter data in table "A" I can add multiple row in the table "B".
My question is:

Assuming that I've started the form from table "A" and entered a first "related data row", when I enter a second "related data row" is it possible to use a value entered in the previou related record even if this is not yet saved and so present in the table "B" database?

[WillowMobileSys · Accepted solution]

I believe the answer is yes. 

What you are referring to are Parent Child relationships - Table A is the parent and Table B the Children.  When entering a Form for Table A and then start adding rows into Table B from that Form, the saves of the children are added to a local version  of the data.  They remain ONLY in that local copy until Save is tapped on the Parent Form - which then pushes both Parent and Child rows to the server and subsequently the datasource for everyone else to have access. 

The child rows ARE accessible to this local version of the app to reference BEFORE the Parent save.  

[simone_checchin]

Sorry, I was wrong using the wrong formula. Indeed, the data is also accessible while the form is being filled out.
Many thanks