Foreign keys in GridGorupingControl

[Administrator]

How do I display a forgeign value in a GridGroupingControl. This is what I''m trying, and I think it should work, but instead of the string (Name) from the "Foo" table, it just displays the Id (e.g., the values of the column "Type"):

GridColumnDescriptor gridcolumndescriptor = new GridColumnDescriptor();

gridcolumndescriptor.Name = "Type";
gridcolumndescriptor.HeaderText = "Foo";
gridcolumndescriptor.MappingName = "Type";
gridcolumndescriptor.ReadOnly = true;
gridcolumndescriptor.Width = 120;

FooTable foo = dataset.Foo;

if(_log.IsDebugEnabled) _log.Debug("Foo contains " + foo.Count); // display s 8

gridcolumndescriptor.Appearance.AnyRecordFieldCell.DataSource = foo; //Also tried "Foo"
gridcolumndescriptor.Appearance.AnyRecordFieldCell.ValueMember = "Id";
gridcolumndescriptor.Appearance.AnyRecordFieldCell.DisplayMember = "Name";

itemGrid.TableDescriptor.Columns.Add(gridcolumndescriptor);

Thank you,
dan

[Administrator]

Try also setting

gridcolumndescriptor.Appearance.AnyRecordFieldCell.CellType = "ComboBox";

If you do not want the see the combo button, set the .ShowButtons property to GridShowButtons.Hide.

Another thing to check is "Id" and "Name" are case sensitive, so they need to be exact.

[Administrator]

Perfect. Thanks.