How to avoid duplicates in combobox?

[jaryszek]

Hi,

I tried to implement into my model solution from here:


https://www.techonthenet.com/access/...values2013.php

but still i have duplicates rows in my combobox:



My rowsource for this combobox is query where i am taking Company name, company number and companyID.
The last one in the most impoirtant because it is a foreign key in my summary table.
So user should take company name and aotumatically i would have CompanyID which is inserting into my summary table.

Query from tbl_slow_spolki as rowsource of combobox:



my tbl_slow_spolki table:



as you can see i have duplicates right here so in my query there are duplicates rows!

It is a way to avoid this via combobox? Or maybe i shoud change my table source?

Thank you for your help and support!
Best Wishes,
Jacek

[pbaldy]

I'd just pull from tbl_Company, which presumably doesn't have duplicates. To use the same source:

SELECT DISTINCT Field1, Field2, Field3
FROM TableName

[gunitinug]

Hey jary.

You can set property called 'limit to list' to on.

[pbaldy]

You can set property called 'limit to list' to on.

That wouldn't stop duplicates in the row source, it would just prevent you from entering something that didn't exist the row source.

[jaryszek]

Thank You Guys for your help!

Sorry my friends, I added mistakenly picture with my old database.
Current picture for relationships is:



So in my tbl_slowSpolki i have duplicates rows and that is why in my combobox there are not unique values...

What can i do here?

Maybe i should create a tab le with unique companies name and numbers - separately from others:



Now table tbl_slow_spolki is a junction table - bridge connecting tbl_ComaponyNames and tbl_Reminders_employee.
What do you think about this solution?

Best Wishes,
Jacek

[orange]

Review the use of DISTINCT in your SQL.
DISTINCT will give unique values, no duplicates, BUT you must be specific in which field or combination of fields you are dealing with.

[jaryszek]

Thank you Orange and glad to read you again,


If you are looking for this model - there is a problem with relationship i think.

I am creating combobox from tbl_CompanyNames.
And now i have unique values - it is ok.

But where can i put my tbl_CompanyNames_nr primary key ?
User from this combobox will take for example number 5 and so what?

I would like to take tbl_slow_spolki.ZleceniodawcaID in order to put it into tbl_Braki into Zleceniodawca_nr_FK field.
How to create a form which will allow to do that?
In other words the main point here is to put Zleceniodawca_nr_FK in tbl_Braki.
If i will write here for example 5, i will be knowing that in tbl_slow_spolki there is company number 5 and for example RemindersID = 3.
How can i achive this?

I think this is a problem with my model again :/
Do you understand me?

Please help,

Best Wishes,
Jacek

[orange]

Generally, if you build a combo with unique values, you may have 2 fields in the combo.
Let's say there are CompanyNumber and CompanyName. You select Distinct to prevent any duplicates.
And, for the combo display you show size 0;1 where 0 represents no length for CompanyNumber, and 1 shows length for display of CompanyName. However, your bound column is CompanyNumber and that is the value that gets stored in another table or control as per your needs.

Here is lots of info on comboboxes.

Good luck

[jaryszek]

Thank you orange,

i think that problem is within my model. Combobox is ok...

I am closing the topic and creating new one.

Best Wishes,
Jacek