I have a lookup field using the "add a record" option.  I had to recover values backed up, I got error messages and an empty data column for this field when recovered.