Search results

Hi I have an Orders database for which I set the Order_ID field to autonumber. The I screwed up playing around and now Purchase Order 0001 has Order_ID number 2. Is there an equation/expression I can put in the Validation rule that will make my PO number = Order_ID minus 1? Thanks

Hi I have what is probably a stupid question but I've been struggling with this one for a while. I have an ordering database which has an Orders table (containing Order ID, Date, Supplier etc) and an Order Line table within which I have a combo box for Product name, supplier, price, VAT rate...

Hi I have an Ordering database where the order form contains a subform with the order lines (Order_line_subfrm). In this subform footer I have 4 currency fields, one f which is delivery fee (default is set to zero). When I add a fee into this field on screen, everything works (i.e. adds up) and...