Thank you for your response.

case max on OrderDetails.OrderStage, will work.

But i am unable to join order details formation from OrderDetails and RelatedOrderDetails tables

case max should take into account Order details...

thank you very much this helps.

i have another query.

OrderHistory table, has list of values for order.

I have to query for last row from the orderhistory table, get addressID,...

thank you.

I want only a particular phone for the consumer.

Each consumer can have 0 phone or more than one phone number,i want only primary phone.

similarly address, consumer can...

thank you very much.

What if, provider and service location address will change per claim.

Or the user while creating the claim should have the ability to modify provider and service...

let me rephrase my requirement.

User is creating a claim for a patient/member (patient address) and provider is doctor(doctor billing address) and service location (where patient was treated).

address is common in...