Hi guys, I tried searching but it's not super obvious which terms to use when you're a nubbin' like me.
Anyway, super easy (I think),
I have a real simple DB for my small business, Customers, Products and Invoices.
In my invoice table I have a products field lookup that has a one to many with the products table (I select which product is sold from the list). So far so good.
Now, I have a bunch of products inside the products table, once in awhile I want to manually type in a new product that will apear in the products table henceforth.
Now the tricky part is I want to be able to specify the cost price of said new product that will go into the products table. Is there a way I can tell access, "if custom product, ask for cost price information" in a dialog, or something similar?
edit- cost price is a field in the products table
Sorry if I get something wrong or if this is super obvious, I've been searching for a few hours now!
Thanks