Hi,

Below is the query i have done based on ur suggestion,

select WorkplaceLocation.[WorkplaceLocCode],WorkplaceDetails.[CompyRegnNum],WorkplaceDetails.[companyName],WorkplaceDetails.[NumOfEmployees],Employee.[EmpName],address.[OfficePhNum],address.[HomePhone],address.[Fax],address.[Address],address.[Address],address.homepage,address.[Email],WorkplaceDetails.[Notes1],WorkplaceDetails.[Notes2],WorkplaceDetails.[Notes3] from WorkplaceDetails ...

ok... 🙂

SQLite doesnot allow to disable autoincrement field,so i thought if there is any way using SQL command.

Thanks for your help. 🙂

Also, i have one question, how to insert FK using insert query

Suppose i have table A containing FK

table A

Id_a

b

c

id_m (FK)

Now i want to do insert...

Thank you very much for your help. I will follow as you said.

Also i have one question, is it possible to disable AUTOINCREMENT field? I am using SQLite DB

Thanks once again for you help. So i have to Normalize.

Basically I am looking for company having all the details of employee working in tat company( i guess your...

WorkplaceCodeWRegNumWorkplaceNameNumOfEmployeesEmpNameOfficePhNumAddressAddress_1Email

105 099-1A Oracle 888 Wang ho 201543115 Hyundai-4-ga Hyundai-4-ga x@hdfc.com

Above is the output when i run below query

select...

Workplace code is like row count as auto increment field. ( i guess i should not make this as primary key otherwise it will map each employee to one row...

Hi,

Thanks for your response.

Workplacecode is autogenerated field and is primary key of Workplace table.

EmpNumber is FK to Workplace (It is the individual emp number)

NumOfEmployees is (count of employees in company)

Fake...