Is it possible to have one table for tracking the bidding process and when the status of the bid is changed to "awarded" have the basic information copy from the bid to an order on a new table for project management tracking?
I have three tables: Customers, Bids and Orders. I want a new order to pull information from the Customers table when the "Customer Name" matches up and pull information from the Bids tables when the "Bid #" matches.
Thanks!