Hi,

I have 2 tables, namely Main Data and Receiving stock details. Both data have a common field that is PCNO.

I wanted to know whether possible to update into my receiving stock details table (Only PCNO field) whenever I key the data into the Main data table.

Hope to receive you guildance soon.

Thank you


Regards,
Richard Tan

I am sorry but I can't imagine why you would want to do that. The tables sound like they have a 1-to-many relationship. I don't see the point of adding a dummy record to the many-side table. What are you trying to accomplish?