Hello friends!!! I want share a table in two companies in the same Database. I know the property DatePerCompany in the properties table, but the table has different dates for every company. If I assign the value YES to DatePerCompany , what’s happening with the dates?
It seems to me that if you create a new company in a database, this new company shares all object definitions with other companies contained in this database. The table property “DataPerCompany” is by default set to “Yes”, which means that the system maintains a separate content (i. e. data) of the table for each company. However in some cases it might be a good idea to share not only the object definition, but also the data - for example ZIP codes. (If I am wrong, I would be glad if someone correct me and I will delete this post; however I do not want to ask questions only, I would like to help others too :). Edited by - karel2 on 2001 Mar 02 09:13:25
Hi Dr. Jones, which dates are you referring to exactly?? Is there a date field in this table that is unique per company? or are you referring to the timestamp given to each record on a SQL table? (If you are implementing SQL Solution) Karel2, you are correct in how DataPerCompany works. 
Kind regards Craig
I thought that Dr. Jones was talking about “data”, not “dates” (when he referred to DataPerCompany as DatePerCompany). Not being a native English speaker, I also from time to time make this kind of mistake. Sorry, Dr. Jones, if it was not the case (as it probably was not).