1 Topic by leob.bernardi (edited by leob.bernardi 2015-01-08 10:28:54)

  • Registered: 2014-07-18
  • Posts: 8

Topic: One ComboBox, two fields [resolved]

Hi! I again.
How can one combobox show data from two fields? example:
Table1 customers
columns
name | phone

table2 contacts
columns
client | date | time | talking

In the form of links would look like this:
[customer - phone] [date] [time]
[spoken .....
...
...
...]

There afford it?

Post's attachments

Attachment icon myvisualdatabase.jpg 30.81 kb, 262 downloads since 2015-01-08 

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

Re: One ComboBox, two fields [resolved]

Hello,


ComboBox have property
FieldName        
Specifies which column of the database table belongs to this component. You can specify multiple fields: {field1} {field2}



But in you case, you need create calulated field for that, because you need fields from different tables.
unfortunately I do not quite understand how it should look ComboBox

Dmitry.
  • Registered: 2014-07-18
  • Posts: 8

Re: One ComboBox, two fields [resolved]

That'S Perfect !!!
That was exactly what I wanted.
I made as follows:

[properties]
FieldName | {name} - {Phone}

Again, thank you so much !! Dmitry

Until next time.