Updating a Table Using Query

[manoj9849967222]

HI All

I have two tables One is "master" & the other one is "child".

The master Table have filds

Productcode -----Number
Productname-------Text

Child Table

Productcode-----Number
Productname--------Text
Amount--------------Currency

Now i have designed a form using Query. When ever i enter Productcode it gives me the productname automatically. I also have a add button in the form.

Every thing is working. But the problem is when i click add button. only the Productcode gets added to the child table Productname is not added.

Please help.

Regards
Manoj

[JKing]

If the productname is being stored in the master table is it really necessary to store it in the child table? If the tables are joined which they seem to be by the productcode then you can retrieve the productname from the master table based upon the productcode in the child table.

[manoj9849967222]

If the productname is being stored in the master table is it really necessary to store it in the child table? If the tables are joined which they seem to be by the productcode then you can retrieve the productname from the master table based upon the productcode in the child table.

Hi JKing

I think you didnot get me.

I have two Tables

1. Product
with fiels Productcode---Number
Productname--Text

Now i want to design a form where i enter the Productcode & the Productname gets populated automatically.This i have done using a Query. when ever i enter the productcode the product name gets populated automatically.

Now i want this data to store in another table. that is the reason i have created another table called "Detail".
With fiels Date------ date/time
Partyname ---Text
Productcode---Number
Productname --- Text
Amount-----------Currency

I have created a form with the above fiels & a command button.

after entering the above fiels. I enter the productcode & the productname gets populated automatically.

Problem comes when i click the command button to add those records to the Table "Detail". Every things get added except the Productname.

Hope you understand me better this time.

Please Help

Regards
Manoj

[JKing]

I understand the problem.... productName isn't being stored in the "Details" table. What I am suggesting is that you rethink your table design. If you have the productName stored in table "Product" then you wouldn't needed to store it in your table "Details". Since the tables are related through productCode you can always retrieve the productName from the table "Product".

Have a look at this article on Table Structure and Normalization. Particularly 2NF.

Normalization