>Hello... I am very new to the Visual FoxPro World... so, if these questions seem basic, they probably are!
>
>I took an introduction class to VFP6.0 and learned the program code for auto-generating primary keys.
>
>Question: Do I have to create a sysinfo table for each primary key located in my tables that I want to auto-generate?
>
>Last night I created 7 stored proceedures and 7 sysinfo tables for my tables. It appears to work fine, however I am not sure this is the best way to do it. In ACCESS you just have to select AUTONumber and it does the same thing. It seems like a lot of work.
>
>Am I doing things correctly? Is there a better way?
>
>Jason Doyle
>MSA Consulting, Inc.
No, you may have just one table with two fields: TableName C, Counter I. Your key-generating procedure will firstly locate needed record (by table name) and then return new counter from this record.
Edward Pikman
Independent Consultant