Bro. I've been all over the internet looking for a video that best explains this project. Saying you have the best video would be an understatement. This is beyond awesome. Good job bro. I'm dropping a like and I am subscribed. Looking forward to even more content from you. Thank you.
I need clarification on one of the queries. Specifically when calculating the totals, I get so many duplicates and the totals themselves are exaggerated. How do I go about it.
@raphaelwanyoro9460 For queries to work perfectly the relationships between the tables used should also be perfectly implemented. Check to see the relationship among the tables or queries used to build your query. If there is no proper table to table relationship (for instance the query is build from other queries as well), you may also link them just within the query builder by draging and droping then set the right linking if its 1-1 1-many or many-1. If the relationship is well set and still getiing duplicated, check to see if there is any grouping that can be applied. Refer to 1:30:33 for the grouping.
Sir, can i combine the tables like the drilling services table and drilling application table because i need only 6 tables in total in my project plzz answer
You can combine the two into one table, but this would involve duplicating and retyping all the details of a drilling service for each record of a drilling application, which may limit flexibility in handling the data. However, it is possible to do so. If you can find a way around and believe it to be a better approach for your needs, then it is worth considering, as long as you understand the question and provide a solution that meets the requirements. There is no specific prescribed method for doing the project; it depends on your preference, so long as your system answers the question as expected.
Bro. I've been all over the internet looking for a video that best explains this project. Saying you have the best video would be an understatement. This is beyond awesome. Good job bro. I'm dropping a like and I am subscribed. Looking forward to even more content from you. Thank you.
hey thanks
Glad I could help. Thank you too for supporting the channel. Much appreciated.
I need clarification on one of the queries. Specifically when calculating the totals, I get so many duplicates and the totals themselves are exaggerated. How do I go about it.
@raphaelwanyoro9460 For queries to work perfectly the relationships between the tables used should also be perfectly implemented. Check to see the relationship among the tables or queries used to build your query. If there is no proper table to table relationship (for instance the query is build from other queries as well), you may also link them just within the query builder by draging and droping then set the right linking if its 1-1 1-many or many-1.
If the relationship is well set and still getiing duplicated, check to see if there is any grouping that can be applied. Refer to 1:30:33 for the grouping.
@@TipTopyTech can i have your contacts
Thanks alot broo....u did a work worth 7 months of work within a week
thanks so much may God bless you
God bless you man 🙏🏾
I REALLY LOVED YOUR WORK BROTHER BUT MY HUGE PROBLEM STARTED FROM THE CREATION OF QUERIES
making queries is very simple but about the formular mmmmh nah dont ask me thats why am here to lear to
Nice work bro
Much appreciated.
You missed out on the Total amount to be paid by each client and the login screen and dashboard please make a video on those. but so far thank you
hello, i want the project can i get in touch
you should edit your video, it's too long and full ads yet it doesn't need to be
Thank you for your feedback. We appreciate your input and will take it into consideration for future videos.
Sir, can i combine the tables like the drilling services table and drilling application table because i need only 6 tables in total in my project plzz answer
You can combine the two into one table, but this would involve duplicating and retyping all the details of a drilling service for each record of a drilling application, which may limit flexibility in handling the data. However, it is possible to do so. If you can find a way around and believe it to be a better approach for your needs, then it is worth considering, as long as you understand the question and provide a solution that meets the requirements. There is no specific prescribed method for doing the project; it depends on your preference, so long as your system answers the question as expected.