Data Entry from one table to another
I'd like to have a button that runs a script that does this:
puts the value of a field in one table into the same field in a related table.
I have the following fields: kp_item_ID and item_name in the first table and kf_item_ID and kf_item_name in the second table.
What I want to do is put the value of item_name from the first a record in the first table into an item_name field in a record in the second table.
Hope this is clear....