• Registered: 2016-10-30
  • Posts: 16

Topic: Pre Purchase Question

Hello.
I'm currently evaluating MVD and so far, I'm very impressed.
I do have some pre-purchase questions though. Hopefully, Dmitry or some other knowledgeable forum member can help.
I know that FormName.ComboBox1.Items.Add('value_I_want_to_add') allows me to add values to a ComboBox without using a dictionary table.
How do I map the "hard-coded" values in the ComboBox to a field in my table? I'd like to let MVD do the "heavy-lifting" of binding the fields on my form to the Database table using the TableName/FieldName properties, but for a ComboBox, all I see is ForeignKey/FieldName - so it's obviously expecting me to use a dictionary table. Any help appreciated.
Many thanks.

  • Registered: 2015-11-13
  • Posts: 652

Re: Pre Purchase Question

Attached is how I would do it.

Post's attachments

Attachment icon Clyde ComboBox.zip 581.79 kb, 382 downloads since 2016-10-31 

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Pre Purchase Question

clyde
Hello.


You can add some data to a table using SQL.
In the property "ForeignKey" you can specify also and table name (just write table name manually).

Dmitry.
  • Registered: 2016-10-30
  • Posts: 16

Re: Pre Purchase Question

@ehwagner - Many thanks for your example application. A hidden text field that gets its value from the combobox and is bound to a field in the table is a great idea.

@Dmitry - I'm still struggling a bit with your suggestion, but will keep at it.