Hi I'm new to the forum and need help with a query, I have 2 tables first table containg a list of items and available "quantity" stock the second table order lines for the items contain in the first table, What I want to do is allocate the order lines where stock is available until the quantity...