I suggest that you have a look at 'relationships' in the help file. That should start you on your way to seeing data in one table from another. As regards 'synchronising' the tables or files that is another matter and would need a better explanation of exactly what you are trying to achieve.
Like I said, have a look at relationships first
Hope that helps
Best way to synchronize the data is to not have two tables (or files) of identical data to synchronize.
depending on what you have in mind here, this link may or may not be useful to you:
It describes how you can use a relationship to either copy data from one table (or file) to another or to just reference the data in the other table without having to copy it at all.
Ok this is what i am trying to DO.
I have created a Inventory Database from the starter solution plus i added some other fileds
NOW i need to use the invoices starter solution as a POS for 2 of my companies.
I need this two "POS" to connect to the inventory and pull quantities at the same time is this something that can be accomplished? and what approach would you recomend?
Thank you very much in advance.
Presumably these are physically separate companies and thus do not share the same local network. If they did, this would be simpler.
It's possible to host the database file either from a computer you configure for this purpose or via a company you hire for the purpose. Then both companies can use FileMaker to link to the same file as clients of this hosted database.
You can update the inventory one sales transaction at a time from this shared database, or do a "batch" update at regular intervals such as every evening after close of business.