GUID field naming

[Ubaidullah]

Hi Bruce,

I am adding GUID fields to my tables. For Nettalk purposes, does it have to be named "GUID" or can it be like "ItemGUID", "CustomerGUID", etc. ?

Thanks
&
Regards,
Ubaidullah.

[Bruce]

Hi Ubadullah,

the primary key field in each table should be named Guid.
Then foreign key fields can be named as table-guid.

For example
Customers
Guid  string(16)

Invoices
Guid   string(16)
CustomerGuid   string(16)  ! link to cus:Guid

Cheers
Bruce

[Ubaidullah]

Thanks Bruce.

Should the primary key also be called GuidKey or can it be different? Reason being, on SQL, key names have to be unique across all tables in a database.

Regards,
Ubaidullah Nubar.

[Ubaidullah]

Bruce, thanks for addressing this on yesterday's webinar.

I have now changed all primary key field names to GuidKey while using the External name to conform with SQL requirements.

Regards,
Ubaidullah Nubar.