auto populate field in table from related table

  • 0
  • 1
  • Question
  • Updated 3 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 3 years ago

  • 0
  • 1
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.