I am working on a form called frmPurchaseBase for entering incoming invoice data.
I have a field called VendorID which is linked to a table called tblVendorInfo where all the details such as the vendor name, account details etc.
VendorID is controlled by a combo box allowing the user to select from a list of vendors names. I also have the form frmCreditorContacts for entering new Vendors. I have set this as the list edit form for the VendorID combo Box.
The problem is that this form is also used for entering information on credit card purchases and quite often a vendor is only used once and many vendors may need to be added. Also, for this type of transaction only the vendor name is needed. It becomes time consuming and inefficient using the list edit form.
Had i designed the system to begin with i would have had separate tables BUT as it stands i have been tasked with fixing someone else's design.
I thought of maybe having an unbound text box with a button which runs an append query adding a new vendor in the VendorInfo. This works but how would i then get the same button to add that VendorID (just created with the append query) to the current purchase record?
It is quite possible that i am going about this the wrong way so if any one has another design suggestion that would be much appreciated.
Cheers,
Taison
I have a field called VendorID which is linked to a table called tblVendorInfo where all the details such as the vendor name, account details etc.
VendorID is controlled by a combo box allowing the user to select from a list of vendors names. I also have the form frmCreditorContacts for entering new Vendors. I have set this as the list edit form for the VendorID combo Box.
The problem is that this form is also used for entering information on credit card purchases and quite often a vendor is only used once and many vendors may need to be added. Also, for this type of transaction only the vendor name is needed. It becomes time consuming and inefficient using the list edit form.
Had i designed the system to begin with i would have had separate tables BUT as it stands i have been tasked with fixing someone else's design.
I thought of maybe having an unbound text box with a button which runs an append query adding a new vendor in the VendorInfo. This works but how would i then get the same button to add that VendorID (just created with the append query) to the current purchase record?
It is quite possible that i am going about this the wrong way so if any one has another design suggestion that would be much appreciated.
Cheers,
Taison
