Topic: Database ID
Hi folks I'm a wee bit confused. Vdb creates its own id for each table. How do I go about adding my own id names from my tables. Or do I not need ?. Also do I just use the relational option for the foreign keys.
Thanks.
My Visual Database → General → Database ID
Hi folks I'm a wee bit confused. Vdb creates its own id for each table. How do I go about adding my own id names from my tables. Or do I not need ?. Also do I just use the relational option for the foreign keys.
Thanks.
Hi Alan,
You really don't need to worry about things like that.
Each record in each table is automatically given an internal ID by MVD.
And when you create a relationship between tables in your database schema, MVD again automatically, uses the internal ID as the foreign key; it's the beauty of MVD that it does all of this for you.
The attached screen shot shows what it looks like 'under the hood' - it's using your own data (taken from my attachment to your previous post in the Reports section of the Forum - https://myvisualdatabase.com/forum/view … 05#p51005) so it should hopefully make more sense.
Regards,
Derek.
I think what my confusion also was when i was trying to import a csv file I had all the id's in the file and it was coming up with too many or too little fields. Again thanks a million and will keep studying this brilliant package and this forum. Keep up the brilliant work.
Alan
If you need to combine data from different sources (databases), you may need global identifiers.
https://myvisualdatabase.com/forum/view … hp?id=8626
My Visual Database → General → Database ID
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi