auto populate field in table from related table

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

Client table is related to Network Table

the network table has 2 fields, Network and Network ID (value I must use in an API)

Client table has a dropdown box for selection of the Network from the Network table.

I need the field for Network ID in the client table to auto populate from the value in Network ID in the Network table.

How?

Photo of Al

Al

  • 0 Points

Posted 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
It seems that you have a relationship where 1 Network has many Clients.

If you do not have one and the drop down box is not =via a relationship, then make a relationship.

Then  on the relationship, add a lookup field to get the Network ID down to the Clients Table.