Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relation
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01225516
Message ID:
01225573
Vues:
17
>I thought a relation would be created between the the header, itens and next ID table

No, there is no relation. In your NextID table you will have two separate records. One for Items table and one for the Header table to hold the last ID.

E.g. NextID table will have two fields
Table    ID
ITEM     10
HEADER   3
There 3 and 10 are just examples and they should be the last ID numbers in each of your table.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform