I'm trying to create a query combining multiple tables together to create a report, but I ran into an error when relationships are involved.
I have one table that holds address information for Facilities we do transports with, a table that holds our mailing address and billing address, & a 3rd table that handles the details of each individual trip.
The detailed trip Table uses a dispatch form to fill in information, and I'm using combo boxes to select pick-up & drop off locations, and each is connected to it's own subforum to show address/phone/ect information. My master field on the form is a number field, and my child field is the autonumber field that holds the unique id for the location to show the details in the subforum.
This has worked just fine with no problems, but now I'm trying to create a report to create individual statements for clients we transport using a query that pulls all the necessary information together. This is a problem as the pick-up & drop-off fields in the table for individual trips hold the ID # for locations, but I have the Relationships set to show the Facility names. This creates a mismatch error since the facility name is a text field, unlike the pick-up/drop-off fields are numbers.
I've tried playing around with the types of fields, but I'm locked into the current design for the dispatch form, and am unsure of ways to redesign this.
Can anyone point me to a knowledge base/faq or anything to help show me the way to fix this?
I'm designing this in '10, but is using a '03 database to work with access '03.
Edit: I stumbled upon "Joining" in Queries, which helped a lot
I have one table that holds address information for Facilities we do transports with, a table that holds our mailing address and billing address, & a 3rd table that handles the details of each individual trip.
The detailed trip Table uses a dispatch form to fill in information, and I'm using combo boxes to select pick-up & drop off locations, and each is connected to it's own subforum to show address/phone/ect information. My master field on the form is a number field, and my child field is the autonumber field that holds the unique id for the location to show the details in the subforum.
This has worked just fine with no problems, but now I'm trying to create a report to create individual statements for clients we transport using a query that pulls all the necessary information together. This is a problem as the pick-up & drop-off fields in the table for individual trips hold the ID # for locations, but I have the Relationships set to show the Facility names. This creates a mismatch error since the facility name is a text field, unlike the pick-up/drop-off fields are numbers.
I've tried playing around with the types of fields, but I'm locked into the current design for the dispatch form, and am unsure of ways to redesign this.
Can anyone point me to a knowledge base/faq or anything to help show me the way to fix this?
I'm designing this in '10, but is using a '03 database to work with access '03.
Edit: I stumbled upon "Joining" in Queries, which helped a lot
Last edited:
