Hi everyone. I am developing an application where I have an ANIMALS table and another MEDICAL_QUERIES table in which I have a field (ANIMAL_ID) that refers to the ANIMALS table. I would like to generate a report where, given an ID_ANIMAL (selected by the user in a combo), it brings me all the medical consultations made by the animal. If I think about it at the database level, it would be something as simple as doing a SELECT FROM MEDICAL_QUESTS WHERE ID_ANIMAL = xxxx. But Iโm not realizing how to do it in Appsheet. Could any of you give me a hand with this?
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |