R
rich1838
I am designing a databse for a small company where many of the products are
available from multiple vendors. Originally, I created a table and form with
basic product info (Inventory #, Description, U/M, Sell Price, MSRP, Actual
cost). I then created a subtable / form for the Vendor information including
their published price. Since the Vendors price is the products Actual Cost, I
inserted a yes / no field into the vendor table and form. I felt that if the
yes/no was checked, I could create an expression calculating product pricing.
this worked, however,
A) How can I make it that only one vendor can be selected at a time.
B) How can I get these calculated values into invoices (I had values
manually entered into the product table fields with formulas on the invoice
and this worked but the idea now is to reduce data entry by entering one
value (Vendor price) and calculating from there)? If there are other Ideas I
am open.
available from multiple vendors. Originally, I created a table and form with
basic product info (Inventory #, Description, U/M, Sell Price, MSRP, Actual
cost). I then created a subtable / form for the Vendor information including
their published price. Since the Vendors price is the products Actual Cost, I
inserted a yes / no field into the vendor table and form. I felt that if the
yes/no was checked, I could create an expression calculating product pricing.
this worked, however,
A) How can I make it that only one vendor can be selected at a time.
B) How can I get these calculated values into invoices (I had values
manually entered into the product table fields with formulas on the invoice
and this worked but the idea now is to reduce data entry by entering one
value (Vendor price) and calculating from there)? If there are other Ideas I
am open.