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 data

Workplace code-1

WRegNum-098-098 (Company reg Number)

WorkplaceName- Oracle Inc

NumOfEmplouees-1000

EmpName - 'John' (I get emp name from Employee table using EmpNumber which is FK to workplace table and using this only to get emp name)

[address -x-102,abc, Newyork

email -x@yz.com

Ph: 01-87483284] (I get address details from Address table and address_id is FK to Workplace table using this only to get address details of company)