I am using A5 V10.5. I know that is old, but I have a good reason for using it. However, I have not done any real serious DB creating for a while and am out of practice.
I have created a browse table for a table I created and am trying to create a calculated field showing the number of duplicates in a field in that table.
The table looks like this:
Part Number Serial Number PO Number
5A/250VP 123456 207544
5A/250VP 654321 207544
CON-6310 456789 207669
CON-6310 987654 207669
CON-6310 123654 207669
It is a very small table of part numbers with associated serial numbers. Each part/serial number combo is unique. When part/serial number is used (referenced from another table) that unique combo is pulled from this table then posted to a history table and deleted from this table. As you can see from the example above, part numbers can be listed several times. I know this table structure does not follow First Normal Form, but there is a reason for that. There are actually only 14 part numbers currently in the database, but each part number has several serial numbers, so each is listed as a separate record. There are currently 81 records in the table. It is not likely the number of part numbers will increase, but the number of part/serial number combos could increase as new parts are purchased and added to the inventory.
What I want to do, as mentioned previously, is create a calculated field in the custom browse table to count the number of each duplicate field value in the table. That should give me a total quantity of each part.
I have searched through the forum and cannot find anything that will help me with this. I know this should be pretty easy but, as I said, I am way out of practice and am just spinning my wheels. Can anyone get me going in the right direction?
I have created a browse table for a table I created and am trying to create a calculated field showing the number of duplicates in a field in that table.
The table looks like this:
Part Number Serial Number PO Number
5A/250VP 123456 207544
5A/250VP 654321 207544
CON-6310 456789 207669
CON-6310 987654 207669
CON-6310 123654 207669
It is a very small table of part numbers with associated serial numbers. Each part/serial number combo is unique. When part/serial number is used (referenced from another table) that unique combo is pulled from this table then posted to a history table and deleted from this table. As you can see from the example above, part numbers can be listed several times. I know this table structure does not follow First Normal Form, but there is a reason for that. There are actually only 14 part numbers currently in the database, but each part number has several serial numbers, so each is listed as a separate record. There are currently 81 records in the table. It is not likely the number of part numbers will increase, but the number of part/serial number combos could increase as new parts are purchased and added to the inventory.
What I want to do, as mentioned previously, is create a calculated field in the custom browse table to count the number of each duplicate field value in the table. That should give me a total quantity of each part.
I have searched through the forum and cannot find anything that will help me with this. I know this should be pretty easy but, as I said, I am way out of practice and am just spinning my wheels. Can anyone get me going in the right direction?
Comment