Need help. How to auto update fill with the value that is already in a table. My table as follows
Table 1
Id
item_code
item_name
comp_name
Table 2
id
item_code
item_name
comp_name
date_in
date_out
So when i want to add data in Table 2, i want the related fill to be auto updated when I put the item_code. The item code is already been filled in table 1. Please help…