Search results

Hi, Could someone help ? Is there a way of allowing user to reference/update from either databases ? If user enters an item code and it is not found in database A, can the program direct it to retrieve/update from/to database B ? Assuming database A and B are item databases with different...

Hi Guys, Have read somewhere that the statement below will help to increment a numeric field by 1 without using Autonumber. [Invoice Number] = Nz(Dmax("Invoice Number", "Invoice Transaction Header")) + 1 This was to be applied Before Update under the event of Invoice Number. Would...

Hi, Could someone help to advise how not to update master file values when price is updated on the form ? Price is retrieved from master file but it should not be updated back to the master file. Thank you and Best regards