Form Structure 1

[xhuck28x]

I am trying to design a form that allows a user to fill and complete a purchase order. Required items for the purchase order include vendor information(TO), processor information(SHIP TO), and line items for the material purchased.

I get a bit confused on how to set this all up. What I want to do is have the vendor(TO) and processor(SHIP TO) autofill once the user has selected a name. Information for these sections comes from seperate tables, each named [Vendor] and [Processor]. I am familiar with autofill queries but my current understanding leads me to believe this won't work since i cannot use multiple queries as a reocord source.

Any suggestions?

I'll stop there as i can go on and on. Please reply if this is not clear.

 

[sfm6s524]

I suggest putting your vendor and processor choices in a multi-column combo box. Set rowsource to a query such as "SELECT VendorID, VendorName, VendorAddress, VendorCity, VendorState, VendorZip FROM Vendor
ORDER BY VendorName;" and set controlsource to your VendorID of your PO table. So now you have 6 columns of vendor data, set the column count to 6, and column widths to 0";1";1";1";0.25";.5" (adjust as needed, first column hidden since hopefully it is your Vendor primary key used to link your PO's to vendors). Assuming the Vendor combobox is named cboVendor, you can now fill in the name textbox by setting the controlsource to "=[cboVendor].[column](1)", etc. Column property is zero based, so column 1 is logically column 2. Also, you may be able remove the Vendor table from the PO forms record source, if it was there before.