Hi,

In the system I am developing we have a field RequestNumber which is
used to identify the request ( by the end user. It's not a primary
key)

So for eg we have the following columns in the table
Id
RequestType (possible values: AIM, CMI, JMI)
RequestNumber
RequestDetail1
....
RequestDetailN

What I want in RequestNumber is  AIM-10 if this is the 10th request of
RequestType AIM
                                                  JMI-120 if this is
the 120th request of RequestType JMI

Is there a way to define the RequestNumber in the mapping file so that
it uses the RequestType property and a select statement.

Maybe there is an easier way doing this.

I would appreciate if anyone can shed some light on this
Thanks
Joe

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to