# Revision history [back]

### Code counting -- How to tally and use table data to validate input

I have been working on this for two days with reference to LibO Help, OO Documentation, StackExchange, and whatever else internet search engines could provide. I have managed various values of 'success' and even crashed LibO Base once, but have not managed to complete what I think is a simple task. My head aches from banging it against this cognitive wall. I must be missing something which is not made clear by any example or tutorial seen so far.

I have two tables. The first and simplest table is omitted from the sample database attached. This first table is just "CodeGroup" and "Description" (both columns are strings) -- it provides descriptive name for each code group -- with CodeGroup as primary key. I will use it for making the automation look nice later, so I left it out.

The second table is "CodeGroup", "Code", and "Tally". The first two columns are strings, and the last is an integer. The table already contains the data which is static and has no need to change -- the code group and the codes.

What I am trying to do is use the codes already in the table to provide a list box or combo box which autocompletes as a code is being typed (fixing lowercase and validating input at the same time) and then, once <enter> is pressed, increases the tally value by one, and make ready for the next code. I would also like to display all the codes and tallys belonging to the same code group after each code tally is updated.

Seems really really simple, yes? I thought I might find a working example or tutorial but nothing I found is designed this way. I am at a loss why I cannot complete this task. I have been experimenting with Forms and Subforms and List Boxes and Combo Boxes and Formatted Fields and Text Fields and SQL and Control properties and Forms properties and on and on ...

I will greatly appreciate expert assistance and give many thanks.

ps: oh. :( i must have 3 karma points to upload the sample database. and I have but 1. I'll append an excerpt of the data below (you'll see the pattern. the real data is different only in detail. each code is unique. each code group contains a varying number of codes, ranging from 4 to 8. the sample has code groups A1 to A5, B1 to B5, and so on, to E1 to E5):

CodeGroup Code Tally
A1  A1G 0
A1  A1F 0
A1  A1E 0
A1  A1D 0
A1  A1C 0
A2  A2G 0
A2  A2F 0
A2  A2E 0
A2  A2D 0
A2  A2C 0
A3  A3G 0
A3  A3F 0
.
.
.
E3  E3D 0
E3  E3C 0
E4  E4G 0
E4  E4F 0
E4  E4E 0
E4  E4D 0
E4  E4C 0
E5  E5G 0
E5  E5F 0
E5  E5E 0
E5  E5D 0
E5  E5C 0


### Code counting -- How to tally and use table data to validate input

I have been working on this for two days with reference to LibO Help, OO Documentation, StackExchange, and whatever else internet search engines could provide. I have managed various values of 'success' and even crashed LibO Base once, but have not managed to complete what I think is a simple task. My head aches from banging it against this cognitive wall. I must be missing something which is not made clear by any example or tutorial seen so far.

I have two tables. The first and simplest table is omitted from the sample database attached. This first table is just "CodeGroup" and "Description" (both columns are strings) -- it provides descriptive name for each code group -- with CodeGroup as primary key. I will use it for making the automation look nice later, so I left it out.

The second table is "CodeGroup", "Code", and "Tally". The first two columns are strings, and the last is an integer. The table already contains the data which is static and has no need to change -- the code group and the codes.codes. The "Code" column is the primary key.

What I am trying to do is use the codes already in the table to provide a list box or combo box which autocompletes as a code is being typed (fixing lowercase and validating input at the same time) and then, once <enter> is pressed, increases the tally value by one, and make ready for the next code. I would also like to display all the codes and tallys belonging to the same code group after each code tally is updated.

Seems really really simple, yes? I thought I might find a working example or tutorial but nothing I found is designed this way. I am at a loss why I cannot complete this task. I have been experimenting with Forms and Subforms and List Boxes and Combo Boxes and Formatted Fields and Text Fields and SQL and Control properties and Forms properties and on and on ...

I will greatly appreciate expert assistance and give many thanks.

ps: oh. :( i must have 3 karma points to upload the sample database. and I have but 1. I'll append an excerpt of the data below (you'll see the pattern. the real data is different only in detail. each code is unique. each code group contains a varying number of codes, ranging from 4 to 8. the sample has code groups A1 to A5, B1 to B5, and so on, to E1 to E5):

CodeGroup Code Tally
A1  A1G 0
A1  A1F 0
A1  A1E 0
A1  A1D 0
A1  A1C 0
A2  A2G 0
A2  A2F 0
A2  A2E 0
A2  A2D 0
A2  A2C 0
A3  A3G 0
A3  A3F 0
.
.
.
E3  E3D 0
E3  E3C 0
E4  E4G 0
E4  E4F 0
E4  E4E 0
E4  E4D 0
E4  E4C 0
E5  E5G 0
E5  E5F 0
E5  E5E 0
E5  E5D 0
E5  E5C 0