Hello everyone,
I have a parts locator database that has a many to many relationship. I set up a search for a part but I also want to be able to look by location. When I use the relationship I setup it makes a duplicate entry since it needs to show all the locations that part is used. Is there a way to filter down to the locations used without the split form showing more than one entry per item number?
Thank you for your help.