Topic: Questions Distinct ComboBox
Hi all,
I have two questions.
1) Can I Distinct a ComboBox without using script?
2) When I have a ComboBox with a RelationShip how can I distinct it?
I want to avoid the same records.
Thank you in advance.
- DriveSoft
- Administrator
- Offline
Re: Questions Distinct ComboBox
Hello,
It's not possible without using script, if you have same records in ComboBox, I think you have wrong database structure.
Dmitry.
Re: Questions Distinct ComboBox
Understood I must have a script.
When the data in the ComboBox are from a table with Relationship how can I Distinct it using a script ?
In the past I used the below script but this script is without a RelationShip
Form1.ComboBox1.dbSQLExecute ('SELECT DISTINCT fieldname, id FROM tablename');
- DriveSoft
- Administrator
- Offline
Re: Questions Distinct ComboBox
if you have same records in ComboBox by relationship, surely you have wrong database structure, script does not help with this.
Dmitry.