I'm new to Codebook and VFP (oh, for the good ole days of proceedural developement :)). Anyway, I'm developing a replacement app for a pawn shop which will have to track numerous different types of item: clients, collateral inventory/loans, sales inventory/sales, etc. As in nearly any type of sales app, everything is tracked by number--client number, loan number, inventory number and so on. Question: Since each CB table requires a PK, would it be proper to use this number for item tracking or would it be more advisable to maintain a seperate number? For instance, in the client table one would have the field 'cID' as the PK and 'nClientNr' to identify the customer. If one were to use only the CB generated PK, would it be better to use interger rather than character?
The thoughts and opinions of the resident 'graybeards' would be greatly appreciated.
©2001 Virgil Bevans |
