Auto-populate based on field selection to a new field
To make myself more clear - I have a table that stores Child ID and Child Full Name. These fields are used as a value list assigned to another table.
Child Intake stores Child ID and Child Full Name
Child Placement has a drop down that pulls the Child ID and Child Full Name as the value list from Child Intake table
i also need to have the Full Name populate into a field on the Child Placement table after the ID is selected.
How can this be done?