M
Megan
I am creating a form to enter in customer prices. I've created a query that pulls the product information and prices from the products table. I created a form from the query and everything is beautiful as long as the customer is already in the table.
When I try to create a new customer prices sheet - it's a different tier, there's nothing in the table so I get nothing but headers on my form
It's a continuous form right now.
I've been trying to figure out how I can create a "template" for new customers so they can add in prices and be appended to the products table. Would it work if my originally query came from another table with a product selection from the original products table. Then maybe I could do an update then append to products?
That's probably confusing.....feels like it to me
Any suggestions would be appreciated.
When I try to create a new customer prices sheet - it's a different tier, there's nothing in the table so I get nothing but headers on my form
It's a continuous form right now.
I've been trying to figure out how I can create a "template" for new customers so they can add in prices and be appended to the products table. Would it work if my originally query came from another table with a product selection from the original products table. Then maybe I could do an update then append to products?
That's probably confusing.....feels like it to me
Any suggestions would be appreciated.