Okay here is my situation. I have 2 Tables. Let's say Table 1, Table 2.
In Table 1 I have a field called 'Main'. I created a relationship, which displays all the entries under the 'Main' in Table 1 in the field under same name in Table 2.
In Table 2 I select, the Entry under the 'Main' and enter a number in a field called 'New' and save.
Whenever I save the Table 2, I want it to show up on another field with the same name under that particular entry of 'Main'. Is there a way I can do that?
In short it is easy to do if they are in the same table. Can I do it if they are in different tables too?