Page 1 of 1
lookup function return funny value
Posted: Fri Sep 18, 2020 10:14 am
by eric
I try to use lookup feature to lookup a Asset DB from my Case Log screen, looks ok on the screen (Computer ID = 1002") (
lookup_screen.JPG
) but once i check the value capture (Computer ID = 5f60773cb63107f") (
computer id not computer id autonumber.JPG
.
Anybody knows how to repair this issue? Please advise me. Thanks in advance.
Re: lookup function return funny value
Posted: Mon Sep 21, 2020 11:52 pm
by admin
eric,
(my example uses invoice and customer not computer and case)
xedit.PNG
When you select a record from a Lookup, an ID is actually being selected and being saved not the actual information you see in the Lookup.
To get the information you see in the Lookup, in a Browse Form for invoices, you'll need to join both tables in the Browse Form.
xform.PNG
You will only get customer information if you join the 2 tables.
xsqlbuilder.PNG
Code: Select all
SELECT
invoice.*,
customer.*
FROM
invoice
JOIN customer ON customer.customer_id = invoice.inv_customer_id
xphpmyadmin.PNG
xbrowse.PNG
Steven