Member Avatar for bettybarnes

hi anyone here knows how to display autogenerated id on textbox in a form?

for example

if i have 2 textboxes

1st txtbox is for CustomerID
and the other is CustomerName

when im gonna add a new record
the customerId is already filled with CUS00002
and im actually gonna input only the customer name

  • 2 Contributors
  • 1 Reply
  • 96 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by zinnqu
Member Avatar for zinnqu

This can be done with your database. Since you can have a "control id" autonumbered into the database, all you need to do is tell the program that you need a new record and pull the newest number from the database as the record is created. This is already implemented in access and SQL/TSQL/MySQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.