Query on Detail part of Master-Detail
Quote from CSSystems on November 5, 2022, 2:16 amIs it possible to query on the Detail part of a Master-Detail relationship?
Let me explain.
I wrote an app which I call YouRinvited (You are invited) using for registration for a Vets Appreciation Dinner.
We have the Honouree and guests of honouree e.g. Wife, Brother one or Both. The guest is linked to the Honouree (of course)
The database is used each year. Some guest of honouree may come one year but not the other.The report I have so far does a query on honouree who said they were coming. Not a problem.
But the 'Guest of' sub-report will list those guests who are not coming as well as those coming. The guest has a boolean field of Attending.(true/false)I don't want to delete their names in case they come next year. I only want to see the 'Guest of' who indicated they were coming.
Is there a way to accomplish this?Sounds like a 'cry' for Sql. If so, I need a lot of help.
Is it possible to query on the Detail part of a Master-Detail relationship?
Let me explain.
I wrote an app which I call YouRinvited (You are invited) using for registration for a Vets Appreciation Dinner.
We have the Honouree and guests of honouree e.g. Wife, Brother one or Both. The guest is linked to the Honouree (of course)
The database is used each year. Some guest of honouree may come one year but not the other.
The report I have so far does a query on honouree who said they were coming. Not a problem.
But the 'Guest of' sub-report will list those guests who are not coming as well as those coming. The guest has a boolean field of Attending.(true/false)
I don't want to delete their names in case they come next year. I only want to see the 'Guest of' who indicated they were coming.
Is there a way to accomplish this?
Sounds like a 'cry' for Sql. If so, I need a lot of help.
Uploaded files:
- You need to login to have access to uploads.
Quote from Vadim on November 5, 2022, 4:47 pm@cssystems
Of course, you can create filters and show only those entries in the table that meet the criteria you want. Including from different fields (columns of your table). In this case, all data will be in the database safely. You will be able to simply display the desired ones.
You can use the NeoDB plugin (you will need the dbfQuery command) or the more advanced NeoDBPro (see the dbpQuery command).
A tutorial on using the NeoDB plugin (formerly NeoBookDB) and the dbfQuery command is on my free course here (you can translate it into any language in your browser). Requires registration on the site (because I use it to teach students) and click under the course description button "Sign up for the course", then this course will be available:
https://distant.orgpsiholog.ru/mod/assign/view.php?id=190
Of course, you can create filters and show only those entries in the table that meet the criteria you want. Including from different fields (columns of your table). In this case, all data will be in the database safely. You will be able to simply display the desired ones.
You can use the NeoDB plugin (you will need the dbfQuery command) or the more advanced NeoDBPro (see the dbpQuery command).
A tutorial on using the NeoDB plugin (formerly NeoBookDB) and the dbfQuery command is on my free course here (you can translate it into any language in your browser). Requires registration on the site (because I use it to teach students) and click under the course description button "Sign up for the course", then this course will be available:
https://distant.orgpsiholog.ru/mod/assign/view.php?id=190
Quote from CSSystems on November 6, 2022, 12:35 amThanks for your comments.
I am well versed in DBPro.
I will work with query on the details table. Just not sure if I can query on master table and details table at same time.
Thanks for your comments.
I am well versed in DBPro.
I will work with query on the details table. Just not sure if I can query on master table and details table at same time.