hello to all and happy new year
I have successfully created a database with xampp. In my data base there are 2 tables company(id, name, address, bank account) workers(name, id, comID, compname, compaccount, workeraddress,) id is the primary key in both tables. Bank acount is a unique field for the comany which means that each company has 1 bank acount.
As it is obvious workers wokr in a company. So i have created a "one to many" relationship between company and workers. What i want is for each new worker when i type the compID, the other fields that related to the company ID to be automatically fullfiled.