Cannot Get Select Field Value to Populate Other DocType

1

Hello,

I have a custom field in the Item DocType, a Select field with 3 options.

I want to pull the selected value through to another custom field in the Purchase Receipt Item.

I have tried to use the Fetch From option, with item.custom_field but I get the following error when adding an item:

Field not permitted in query: status

and the following error if I try to save

	"exception": "pymysql.err.OperationalError: (1054, \"Unknown column 'status' in 'field list'\")"
}

Anyone know a way around this?