I’m trying to Import data to populate a view, the data imports into my view but when I try to make a selection from a ‘Dialog List’ field in the Main Doc I can’t see the data and I get the following error: “Keywords must be text!”. If I clear the imported data and key in data using the Material Code form in the database it works. The file that I’m importing from is a WKS (1-2-3).
**Main Document Form:
Field called: MaterialCode - Dialog
List/Editable with formula @DbColumn(“”:“”;“”:“”;“LookupMaterialCode”;1)
Field called: MaterialDesc - Text - Computed with formula @If(MaterialCode = “”; “” ;@DbLookup(“”:“”;“”:“”;“LookupMaterialCode”; MaterialCode; 2))
** Material Code Form:
Field called: MaterialCodeUp - Text/Edit
Field Called: MatericalDescUp - Text/Edit
**LookupMaterialCode View
1st Column: MaterialCodeUp - General
2nd Column: MaterialDescUp - General
** Import File WK3 (1-2-3)
Ist Field: MaterialCodeUp - General
2nd Field: MaterialDescUp - General
I have tried columns as Text, Number, General. ??
Hopefully there is something simple that I’m missing.
Appreciate any help
Regards… Marion