super simple newb question!

[jesburger]

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

[RuralGuy]

Did I hear you say you were using a LookUp Field? http://access.mvps.org/access/lookupfields.htm

[jesburger]

I see. Seems my Lynda.com access tutorial doesn't explain to me to "correct" way to do this. How can I tell my invoice table to look up a line in the products table without a lookup?

[RuralGuy]

You can simply use a query that joins the two tables on the proper field.

[jesburger]

​ill check it out, thanks bromigo