Search if same combination is already in the table, add if not found.

**DesoxyN** · 01-03-2023, 01:28 PM

Hello a very beginner Access user here,

So I need help building a basic application for the data I already have. Imagine 2 columns with data and depending on the given data and data count, we would like to create a combination ID for these. For example in the image below, first two columns (Label 1-2) has the label data and the 3rd column is the combination ID. So if I would like to use, [A 1 ; A 2 ; A 3 ; B 2] (4 entries) it should create [C1] as combination ID. Also if I would like to use [A 1 ; B 2] (2 entries) it should create [C5] as the combination ID. The real data is more complicated and I simplified it as best as I could.

In the future when I search with new label dats, it should warn me if I already have a dedicated combination ID for the given data. For example, if I feed [B 3 ; A 3] or [A 3 ; B 3] (without considering the feed order) to it once again in the future, it shouldn't create a new combination ID. Instead it should show me "You already have combination ID for this entries. The combination ID is: C2". Please reply back for more details. Any recommendations are welcome.
Untitled.png

**Gregor y** · 01-20-2023, 01:36 PM

Oh my, you appear to have a classic Bergholt Stuttley design problem, and your first best solution would be to fix this if at all possible.

In theory you could more or less divide the data by the lookup(with a couple extra half steps for exact division)...
(assuming the simplified case where the duplicate entry for [B 1 C4] is a typo, and can be avoided by a uniqueness constraint on the table)
ExampleDiv-000.png
ExampleDiv-001.png
ExampleDiv-010.png
ExampleDiv-020.png
ExampleDiv-030.png

...