Hopefully someone can tell me if this is possible or if I'm trying to do something impossible.
I have two tables Packages for the packages we send and then individual applications in an Application table. Multiple applications go in one Package so I have the tracking ID in both tables with a one to many relationship from Packages to Application.
I intended that users create a package and then assign applications to that package in a combo box that queries for active packages. To make it easier to balance weight between Packages I created a query that summed the total weight held back each application
(Sadly I can't post an image of the query)
This worked fine if there was already an application with that tracking number and a weight but if I'd just created a new package so no entries in the application table or no weights yet it wont find anything. Is there a way to show all the Packages even if there's no information in the application table? I tried Sum(Nz[Weight,0]) which was the only advice I found searching but this had not effect.
I have two tables Packages for the packages we send and then individual applications in an Application table. Multiple applications go in one Package so I have the tracking ID in both tables with a one to many relationship from Packages to Application.
I intended that users create a package and then assign applications to that package in a combo box that queries for active packages. To make it easier to balance weight between Packages I created a query that summed the total weight held back each application
(Sadly I can't post an image of the query)
This worked fine if there was already an application with that tracking number and a weight but if I'd just created a new package so no entries in the application table or no weights yet it wont find anything. Is there a way to show all the Packages even if there's no information in the application table? I tried Sum(Nz[Weight,0]) which was the only advice I found searching but this had not effect.
