I would like to get a value of a field in the database based on a receipt number, there is a field called smWiz30UnitNum that has the unit number i need. There is already some querying to determine if the receipt number exists. Each record in the database has both a receipt number and a UnitNumber. The user enters the receipt number in the GUI and I need the code to also retrieve this smWiz30UnitNum value based on the receipt number they enter
I will provide access via teamviewer so you can complete work