Advise & How To

[Sullaway]

A section of my DB will allow users to do a price quote. This price quote will be a combination of several vendors products. My thoughts are to have a subform on the price quote that will take the price quote details. In those details, after the user makes a choice of product, the vendorsID will also be inserted.

Now here is where I need advise. "Ideally" what I would like to do is allow the users to click a command button (or something) that would take this price quote, separate the vendors according to the vendorID and start new Purchase Orders for each vendorID found along with the info on the price quote that goes to that vendor. Another words, if user chooses products to fill out the price quote from VendorA & VendorB then when they click the command button, 2 Purchase Orders are started, VendorA with everything that pertains to them from the price quote filled in and VendorB the same.

Could someone please take time to tell if this is a bad idea? Is there a better way?

IF this is "doable" what would be the best way to get it done?

Thank you for your time and sorry this is so long,
Shane

 

[jimmythegeek]

That's not a bad idea! All you would need is a Purchase Order table, and a PO Details table, just like an Order and Order Details table. Include POID, VendorID (FK), CustomerID (FK), Date, and any info that is specific to an individual PO in the PO Table. In the PO Details table, you will need a DetailID, POID (FK), ProdID (FK), qty, and anything that is specific to an individual line entry for the PO.

When the user clicks the button, you generate a single PO for each Vendor, with the appropriate details from the Quote form. Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[Sullaway]

Jim,

Thank you very much for taking the time to answer my question. I really appreciate your advise.

Shane