General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Sounds like vou_no, code and Rate are the PK. Alternatively we can just add auto-increment identity column to be a PK and the combination of vou_no, code, Rate will be unique index.
yes I think auto-increment identity column will be the best solution.
I shall upload a Prpared form with invoice table for more discussion.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only