Hi I have an attractions table linked to OrderDetails (which will contain the details of how many tickets and type of tickets). Once a person has selected the attraction they can then choose the number and type of tickets they want. The issue I have is that the OrderDetails is then linked to the Order table (which shows the totalprice, deposit required etc for all tickets chosen).
The best way I can think to allocate an order number in the OrderDetails table is to set the default value of the OrderNo field in the Order details to the next OrderNo from the Order table. I have tried setting the default value to MAX OrderNo +1 using all sorts of SELECT statements but I keep getting syntax errors. Is it possible to do this? Can anyone help please?
Thank you in advance.