CODEWITHSUNDEEP
sqlitedelphifiredac
user3140961
user3140961

Reputation:

How to create a Lookup field that gets its value from another Lookup field in a FDTable with Delphi 11?

In my Delphi application I have three FireDac tables A,B,C connected to a SQLite database. Table A has a lookup field in the result field of table B. This result field is a Lookup in a field of table C. When I run the code I get the error "there is no such column LookupFieldB". Apparently table A is looking at the physical table B where indeed there is no such field. With SQL code I can handle it with the JOIN command but here I am using tables and not queries.

Is there a way to achieve this?

Upvotes: 0

Views: 62

Answers (0)

Related Questions