TV shows the ID while DV shows the actual data

[salemsaleem76]

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

[DevGiu]

Has you set this field as a lookup?

[grimblefritz]

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.

[salemsaleem76]

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

[grimblefritz]

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.