Thread: Ref numbers
View Single Post
  #3 (permalink)  
Old January 16th, 2008, 11:29 AM
planoie's Avatar
planoie planoie is offline
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

Ask yourself these questions:

Do you have it working? Are you content with it working this way?

Are business rule such that this is an acceptable solution?

When you ask
Quote:
quote:
Is this the right way to go about it?
are you asking if it's the right technical solution (i.e. second table with a text field for ref "#" instead of another solution) or are you asking if this is the right logical solution (i.e. appending a char to the end of an integer to indicate re-submitted requests)?

Echoing my previous questions: If the logical solution is acceptable by your business rules and the technical solution works, then sure, it's a perfectly fine way of doing it.

-Peter