AppGini Community Forums

I have a Invoice Table (with 3 fields InvoiceID, InvoiceDate, CustomerLookup) .
The CustomerLookup is a lookup field of Customer Table which has 2 fields(CustomerID, CustomerName)

I need to get the CustomerID of the customer from a given InvoiceID

$Invoice_from = get_sql_from('Invoice');
$Invoice_id = intval($_REQUEST['InvoiceID']);
$Invoice_fields = get_sql_fields('Invoice');
//Need the syntax to get CustomerID for a given InvoiceID

Hi,

acutally, if you need the CustomerID, this is the data stored in the CustomerLookup field of the Invoice table.

SELECT CustomerLookup from Invoice where InvoiceID = ID_YOU_SEARCH_FOR

Appreciate it will try

Hi
I used I get this error
Parse error: syntax error, unexpected 'CustomerLookup' (T_STRING) in /mydomain/TEST.php on line...
Please advise

Sorry

I was able to figure that out
it should be The key as sqlValue instead of sql

Thanks