I’m trying to pull data from a database using a process order # column as a primary key. the hurdle I am trying to get through is I need to a lot the material number to a tag in the PLC. I’ve attached a screen shot of my database for reference.
for example in the table I use the process order number as my index column but I need to also look at the material number and put the quantity of the ingredient in the right register in the PLC
Process order(idpk_test) # 2210 Material# 50002500 I need to evaluate both as index columns and move the quantity in value_column1 (1252) into the PLC tag.
any thoughts? this one has thrown me for a loop.