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
Bookmarks