Happy Friday everybody!
I'll admit that I just started using forms, so I'm hoping this is an easy question for you guys. I have 2 different tables I'm using. One is called "Carrier Information" that has a variety of information, including carrier name, address, website, contact name, contact number, contact email, etc. I have another query, which is called "Carrier Spend & Tonnage", that uses the carrier name and shows all of the shipments that carrier has made, including the shipment month, the lane it shipped on, tons move, and money spent.
I'm trying to combine these 2 tables/queries into the same form. I currently have only worked with the "Carrier Information" table, and I have it set up where the carrier name is a combo box, and when you select the carrier you want, it updates the rest of the information. Now I'm trying to include the "Carrier Spend & Tonnage" query into the form too, so when the carrier name gets updated in the combo box, it lists the lanes it shipped on, the tonnage, the spend, and the shipment month.
I don't know if it'd be possible, but having something similar to a pivot table would be perfect to be able to sort the lanes. Maybe transferring the form into a report would work better. Like I said, I'm a newbie, so any help would be much appreciated!
Thanks in advance for your help.
Adam