Having trouble creating a form - need some advice...

[noalig]

I have a table for transactions, which is linked to a table of clients via a “CustomerID” field. In creating a form to enter the transaction, I would like to have a dropdown list of customer names from the Customers table, from which the selected name would result in the CustomerID being captured in the transaction input form.

I created a list box trying to use the following sql:

SELECT DISTINCT “CustomerID” || ’ - ’ || “Last Name” || ', ’ || “First Name”, “Last Name” AS “Client” FROM “TableCustomers” Where “Active” = 1 Order by “Client” ASC

It doesn’t return any entries.

Where have I gone wrong?

[ManoEngel]

SELECT DISTINCT “CustomerID” || ’ - ’ || “Last Name” || ', ’ || “First Name”, “Last Name” AS “Client” , “CustomerID” FROM “TableCustomers” Where “Active” = 1 Order by “Client” ASC