form data will not populate in table

[bobsakamato]

Greetings, first timer.

I developed a query that auto-fills in the "price" and "name" of a product based off a "product code", the query works fine. I then developed a form based off that query, and again on the form itself, if I type in a product code, and hit tab, the price and name are filled in. The problem is when I then go to the table only the product is there, the price and name field are blank.

Product code is a primary key in my products table but not in the charges table which is the table I am trying to fill from my form.

I know this is something obvious, I just cannot figure out what the problem is.

Any help will be greatly appreciated.



Thanks.

[RuralGuy]

Unless there is some historical reason to have this data in more than one table, it sounds like it is working perfectly.