My first Database Integration: Cannot select specific records 关注
Hello everyone! I'm working on an integration that prints a label every time a part is assigned to our stockroom. I have designed the integration to detect files based on their transaction date (PartTran.TranDate field in DB) and assigned location (PartTran.Warehouse2 field). Any transaction that ocurred after yesterday with a destination of the Stockroom should print out a label for the part that was moved. Currently when I test this integration, it prints labels at the correct time-- but it doesn't print the correct part number. It seems to be printing the first part number pulled by the database index every time, and I'm not sure how to specify to my label which part # it should print. Can someone help a newbie out here? Thanks!