How to show the data related to an ID instead of the ID?
In summary, I have a database (Access) with 4 related tables, as seen in the picture:
In Delphi, I have a TDBGrid that shows the data from the "resultas" table (using TADOTable), as seen here:
As you can see, the field for the test id shows numbers (id of the test). What I want is to show the test name instead of that number. Or, can I add a field (in Delphi) that shows the name of the test related to the id (a calculated field, maybe)?
Solution
You need Lookup field defined in TADOTable component which is responsible for "Resultas" table. Defining a Lookup Field
Keep in mind that big datasets could result to poor performance. The correct way is to use SELECTs with JOINs in TADOQuery.
- ERROR: insert or update on table "promos" violates foreign key constraint "fk_businesses_promos"
- Storing Friends in Database for Social Network
- How to pass data.frame for UPDATE with R DBI
- How to randomly select rows in SQL?
- How can I get data from the OpenTelemetry collector into PostgreSQL?
- How to save Some Dynamic data without duplications in SQLite
- DDEV is there a command to (re-)create an empty database?
- Do transaction in Django make things faster
- Performance comparison of using Redis hashes vs many keys
- Does the prepared SQL statements in a stored procedure make the performance better?
- solve error "The entity cannot be tracked"
- Create own IVR that will access Database
- PostgreSQL: Export database to .sql file
- What is the "N+1 selects problem" in ORM (Object-Relational Mapping)?
- With python-oracledb what does 'DPY-4027: no configuration directory to search for tnsnames.ora' mean
- How can I get info from 3 table in one request in surrealQL?
- How to generate SQLite entity relationship diagram from database file
- How do ACID and database transactions work?
- what exactly happen when transaction commit but database crash
- Create Postgres database using batch file with [template],[encoding],[owner] and a .sql file
- Saving credit card information in MySQL database?
- How to use contain in GraphQL query
- MySQL: Order by Count(*)?
- Connect PHP to IBM i (AS/400)
- How to permanently modify a dictionary in python?
- Does Postgres support 'ON DELETE CASCADE' with composite foreign Key
- How to insert data into table2 when a new row is inserted into table1, while avoiding duplicates in table2?
- get number of updated documents mongo
- NameError: name '_mysql' is not defined after setting change to mysql
- How to optimize an "optimize" MYSQL query that takes a lot of time