how i can select the latest order for a customer in oracle forms

[ghssal]

how i can select the latest order for a customer in oracle forms and save this order as a new order whith new date.
i use GROUP BY customer_ID and MAX(order_date) but i get another customer_ID and order who share the 'order_date' och inserted before a pressing issue.

the Trigger as
select .....
from customer_order, (
select customer_ID AS B, MAX(order_date) AS S
from customer_order
GROUP BY customer_ID)
where :customer_ID = B and order_date = S;

[debasisdas]

how can that return another customer details since you are passing the customer id in the query.

[ghssal]

how can that return another customer details since you are passing the customer id in the query.

This is what happened , i believed 'GROUP BY(customer_ID ) select the first one in the group MAX(ORDER_DATE).

The idea are when you want to insert a new order, you will enter by the customer_ID and you will get the latest order för this customer and save the new order with new order_date.

[amitpatel66]

So when you create a n ew order, the order date will be defaulted to SYSDATE right?