hassanlabban
Registered User.
- Local time
- Today, 10:45
- Joined
- Oct 25, 2014
- Messages
- 23
Hello Friends
i am not a newbie but i am facing a small issue and seems not able to get around it.
i have a database (warehouse management system) which i developed. now the need risen to create a kind of reservations table or module for stocks which are actually required to be reserved or put on hold, but still are not out of the total inventory count.
i tried creating 2 tables (tblTransactions & tblReservations), and things are going very well when it comes to registering a reserve, and then converting the reserve to a transaction.
the only problem am facing is when i want the query to show me the current stock on hand from the tblTransactions and in the second column to see the quantity reserved from the tblReservations.
i tried the Union and Union All queries, but am getting a multiplied number of data which is giving me wrong totals in the end result.
any ideas on how to get this solved or getting around with it? specially that this database is having more than 50,000 records so far registered on it and its increasing, and changing the database engineering is not an option at the moment.
i would really appreciate your help and guidance and ideas in this
i am not a newbie but i am facing a small issue and seems not able to get around it.
i have a database (warehouse management system) which i developed. now the need risen to create a kind of reservations table or module for stocks which are actually required to be reserved or put on hold, but still are not out of the total inventory count.
i tried creating 2 tables (tblTransactions & tblReservations), and things are going very well when it comes to registering a reserve, and then converting the reserve to a transaction.
the only problem am facing is when i want the query to show me the current stock on hand from the tblTransactions and in the second column to see the quantity reserved from the tblReservations.
i tried the Union and Union All queries, but am getting a multiplied number of data which is giving me wrong totals in the end result.
any ideas on how to get this solved or getting around with it? specially that this database is having more than 50,000 records so far registered on it and its increasing, and changing the database engineering is not an option at the moment.
i would really appreciate your help and guidance and ideas in this