Hi John,
My user has a new demand for data entry on the form "New Cargo Collection Input" having subform "NewCargoCollectionInputsubform".
The situation is that the goods received from different clients have different Products in different Cartons, some times the Product is same, but packed in different cartons having different quantity and different weights. So there entry is made separately for each carton.
On the form there is no such control to mention that there are total how many cartons for this particular "ConsignmentNo" and Client. In different reports we get total cartons from different queries and checks, most of these are with consultation with you and your worthy suggestions and help.
Now the demand is that some times some clients do deliver some products in bulk packed in many cartons having normally same weight of each carton. Suppose a product "A" has 300 cartons or bags with same product and same weight of cartons or bags, my user needs instead of entering 300 cartons separately one by one, he may be able to make a single entry for these 300 cartons.
Now i am not getting the solution how to manage it.
Record Source of subform is:
SELECT CollectionVoucher.ConsignmentNo, [Consignment Number].ExportDocs, CollectionVoucher.Route, CollectionVoucher.ClientCIN, Clients.ClientName, CollectionVoucher.Destination, CollectionVoucher.DeliveryVr, CollectionVoucher.DeliveryVrDate, CollectionVoucher.CartonNo, CollectionVoucher.CartonSuffix, CollectionVoucher.TripNo, CollectionVoucher.UnitOfCarton, CollectionVoucher.ProductID, Products.ProductNameEnglish, Products.ProductNameRussian, Products.HSCode, CollectionVoucher.BrandName, CollectionVoucher.ProductQty, CollectionVoucher.UnitOfQty, CollectionVoucher.WeightOfCarton, CollectionVoucher.UnitOfGrossWeight, CollectionVoucher.[Net Weight], CollectionVoucher.UnitOfNetWeight, CollectionVoucher.UnitOfValue, CollectionVoucher.Rate, CollectionVoucher.Amount, CollectionVoucher.ID
FROM Products INNER JOIN ([Consignment Number] INNER JOIN (Clients INNER JOIN CollectionVoucher ON Clients.ClientCIN = CollectionVoucher.ClientCIN) ON [Consignment Number].ConsignmentNo = CollectionVoucher.ConsignmentNo) ON Products.ProductID = CollectionVoucher.ProductID
ORDER BY CollectionVoucher.CartonNo, CollectionVoucher.ProductID;
Help required please.
Regards,
Khalid
__._,_.___
Posted by: Khalid Tanweer <khalidtanweerburrah@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar