company(companytype) is a FOREIGN KEY in this case.
c_type(ID) is a Primary key then it will be automaticlly incremented. My question is : when the c_type(ID) will be incremented , will company(companytype) be automaticlly incremented too ?
When entering data, users are asked to select the company type, if it exists it will be used in the company table else a new one will have to be created.
Thanks in advance