I am building a simple database and I would like to focus on 4 forms : 

• Companies: legal company details
• Addresses: a list of addresses, zipcode, city, aloso defined by an "address name"
• Sites: association of a company and an address, because companies may share the same address. I have two lookup fields by company legal name (relation to Companies) and address name (relation to Addresses)
• People: all details for on person with a lookup field to Sites, so that each person is linked to a site, and we should the be able to access Company and Address, and all the fields of these two forms

1 - I would like to have a calculated field in Site, so that a Site name is build by concatenating the Company name + Address name

2 - I would like to create a People report able to display the data from Companies and Addresses so that each person record displays the company name and the specific address site. But... But People is related to Sites which is related to Companies and Address and it looks like I can display in the People report data from Sites but not from Companies and Addresses to which Sites is related. A problem with Child field? It is not possible to display fields when they do not belong to directly related forms?

Any idea?

Many thanks in advance.

Cedric

Sites (Companies+ Addresses)

Site (lookup field displaying the "address name") to choose among the different addresses.

People with two lookup fields for Company and Address but I would like to have a unique lookup field to Site while being able to display full addresses and company details in the people report.