Whenever I enter a value in a particular field in a Table, how can I make it populate in the same field of another table?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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?

Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Markus

Markus

  • 0 Points
I would think so, since you already have the references between the tables.  In my experience when accessing lookup information, you may have to refer the record # rather than the typed text.  In my case, I was using a URL Formula to update a child record.

Can you provide more specifics?  I am not understanding what your end goal is.  Are you using something like an inventory list that you want to be accessed by an order form, for example?

Thanks!
Photo of Craig

Craig

  • 0 Points
This might not be possible, but we could take another look. Please open a QuickBase Support case if needed: http://www.quickbase.com/user-assistance/Default.html#getting_support.html
Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points
Actually, I think it might not be possible too. I knew how to do it from Main table to child table but not the other way. But I could figure out some other way. Thanks.