Hello
There are no special properties for that but you can use TColumn.NotInList event to assign
RefId field when user enter 1 or 2 in the EditBox.
Code:
procedure TForm1.DBGridEh1Columns1NotInList(Sender: TObject; NewText: string;
var RecheckInList: Boolean);
begin
if DicMemTable.Locate('Id', NewText, []) then
begin
//Assign RefId field in the MainDataSet
MemTableEh1RefDicId.Value := DicMemTable.FieldByName('Id').Value;
RecheckInList := False;
end;
end;
You also need to set Column.LimitTextToListValues = False to allow enter any vlaues in the LookupComboBox
Demo Project is attached