I currently have a database that maintains vendor information.
The vendor is the primary key. I have a combo box when you select a vendor name and then a form comes up with all of the vendor information.
I would now like to print contracts off of the database. These contracts could have up to 4 vendors associated with them.
I need a way to select and display the vendors and their address information on a form and then I need it to print on a report.
The only way that I could think to do it was have a contract screen where one vendor is selected and then all of the contract information is entered. Three other forms could then be opened to enter the other vendor information. On these forms, you would select the vendor name from a combo box and then the vendor number and address would be "looked up" and displayed into list boxes. The only problem is that the looked up values are not showing up in my contract table. I have columns in the contract table for vendor2, address2,....., but the info does not show up there.
Is there any way to do this?? I do not want the user to have to retype in the information!
Thanks!
The vendor is the primary key. I have a combo box when you select a vendor name and then a form comes up with all of the vendor information.
I would now like to print contracts off of the database. These contracts could have up to 4 vendors associated with them.
I need a way to select and display the vendors and their address information on a form and then I need it to print on a report.
The only way that I could think to do it was have a contract screen where one vendor is selected and then all of the contract information is entered. Three other forms could then be opened to enter the other vendor information. On these forms, you would select the vendor name from a combo box and then the vendor number and address would be "looked up" and displayed into list boxes. The only problem is that the looked up values are not showing up in my contract table. I have columns in the contract table for vendor2, address2,....., but the info does not show up there.
Is there any way to do this?? I do not want the user to have to retype in the information!
Thanks!
