R
Racer57
I have a Work Order database that I want to be able to add plants to order.
There is a table that has a list of plants and their price, then another
table that stores the plants that I select to purchase along with their
quantity and price for a specific job.
I envision either a datasheet view of the plants available and then I select
or copy them into the job table, or a window similar to the window that pops
up on some of the Wizards where you can highlight a field in the left window
and move it to the right window.
There is a table that has a list of plants and their price, then another
table that stores the plants that I select to purchase along with their
quantity and price for a specific job.
I envision either a datasheet view of the plants available and then I select
or copy them into the job table, or a window similar to the window that pops
up on some of the Wizards where you can highlight a field in the left window
and move it to the right window.