how to use TDBLookupComboBox with xDataClient for a foreign key

BIZ TMS XData
5

Hi Wagner
Thanks for all details
I tried to follow your advice about Keyfield for DBLookupComBox
I change property to

  • KeyField = Self

But unfortunately an error "field Self not found" is fired like it doesn't attach this object reference to something existing. I guess it was something to create.
To help others TMS users, I had to defined here for ADS_Departement a field named "Self" as Integer.
It will refer to ID of object in list from ADS_Departement

Then DBLookupComBox with :

  • DataSource = DS_Users
  • DataField = departement_id
  • ListSource = DS_Departements
  • ListField = departement_id;departement_nom
  • KeyField = Self (the one from new specific field)

The ComBox is well populated with name of department for each users and when changed it updates the id of foreign key in users table.

Wagner, I guess will be useful to get a such example in xData doc, as it's a really powerful feature from this framework.

Many thanks Wagner.

1 Like