Join key not in recordest

[chermiti]

hi every one,



I have a following data base
I made a query ( invoice= facturation in french) in order to calculate the price by multiplying price per m area ans the arer, it's ok for the first customer, but once i add another customer in customer table with the different informations, the querie (invoicing) show me the following message "join key of table "contracts" not in recordest

thank you in advance

[orange]

Please tell readers about your proposed database.

How do Invoices relate to Contract and Customers and Locations?
The subject matter is not clear, to me at least.

You should only use alpha and numeric characters and "_" underscore in field and object names.
Avoid embedded spaces and special characters.

There are several free data models here
http://www.databaseanswers.org/data_...ices/index.htm

Good luck.

[chermiti]

Please tell readers about your proposed database.

How do Invoices relate to Contract and Customers and Locations?
The subject matter is not clear, to me at least.

You should only use alpha and numeric characters and "_" underscore in field and object names.
Avoid embedded spaces and special characters.

There are several free data models here
http://www.databaseanswers.org/data_...ices/index.htm

Good luck.

thank you for the link