Hi All 

Im fairly new to zoho creator. I currently have 3 forms which i have lookups on each form.

I am wanting to Auto-Populate the "Owners field" when a Horse is chosen from the dropdown lookup on the form "Background Info". A few questions. 

1) What type of Field Does Owners need to be on "Background Info Form"

2) Do i need to add or modify and of the relationship data as screen shot below?

I have tried adding a workflow: (But it appears to be doing nothing)

while a record is being created or edited

Execute if horse is not null 

on use input on Horse