AppGini Community Forums

Hello Everyone,

I've the following case and I need help with plz:

Table D you select a record from Table C and it populate some fields on of them is X. X itself came to Table C from Selecting a record on Table B, X get in Table B from selecting a value of a field in Table A

Now my problem is that when I open the Table View of D, I see the related ID that connected B & C. so it just show the number. When I open the record it self it shows the actual name as it appears in table A.

The question where I should I add a select SQL statement to resolve the name from ID

Thanks,
Salem

Has you set this field as a lookup?

Let me see if I follow this, as it seems you have a cascade of lookups.

My use of <-- is to indicate "left is looked up from right"

Table A is a lookup table

Table B.X <-- Table A.some_field

Table C.X <-- TableB.X

Table D.X <-- Table C.X

I'm sure that must be incorrect, since B C & D would all get the same value (from A) -- however, but that's how I understood the original description.

I think I "may" know where is the problem but still need to have it resolved. It could be because I did not select the Order ID and select other field:

A is Customer Table with X is Customer Name
B is Quote Table and Select Customer Name through a Lookup from Customers Table
C Is Order Where you Select the Quote and auto populate Customer Name

Up to Now TV shows the correct Customer Name

D is Follow-up Table where you select A Job field from Orders Table and it auo populate the C Name

Now within the Detail View of Follow-up I can see the Customer Name but In Table view I see the Quote ID

On a related Item, where we can adjust the query we adjust inside the "Advance Lookup table" without generating the code again?

Thanks,
Salem

Not sure on the cascading customer name thing.

As to where the SQL query lives, create a query with some unique string in it. Then generate and grep the source. That should make it easy to locate.