title: Best way to retrieve last records values inserted into database
body: <p>I'm saving a record into a customer table, and the customer table has an customer number that auto increments. I would like to know what is the best way to get that newly generated customer number directly after it was created? For example, let us say the customer table has 3 columns, ID, Name, Surname. I use the following code:</p>
  <pre><code>database.tbCustomer.Insert;
  database.tbCustomerName.Value := edtName.Text;
  database.tbCustomerSurname.Value := edtSurname.Text;
  database.tbCustomer.Post;
  </code></pre>
  <p>So once I have done this, I need to get the ID that was created, as I need to use that as a FK in another table. So the easy way I suppose is to just go to the last record in the customer table, but that gives problems if more then 1 person is creating customers.</p>
  <pre><code>database.tbCustomer.Last;
  </code></pre>
  <p>but that approach can lead to the wrong ID being returned if more then 1 customer gets created at the same time. So how would I get the customer ID for the customer that I just created? Using Delphi, and storing the data on mysQL, using FireDAC.</p>