SQL and Identitys

[osquiabro]

which is the best approach for management  Parent/Child with Nettalk and SQL Server.

I needed a form with parent data and childs data but i don't have the parent id, for desktop application i have Super Invoice.

[Bruce]

Hi O,

you can use which ever id scheme you prefer for SQL.
Personally I use the "random string" approach - ie I don't auto-number at all. But this is just Clarion code so you can do server-side auto numbering, or client-side auto numbering - there are arguments to be made for both approaches.

cheers
Bruce

[osquiabro]

Bruce, i always use Identity with Sql Server and use superInvoice when need a childs in a form without know the parent id, then after parent inserted the superinvoive capture id and then save a childs, how i can create similar approaches with NTWB.