In Manage | Database | Relationships, you can add table occurrence boxes that link to tables in another file. Once you've done so, you can add layouts, portals etc that refer to this table just as though it were part of the same file. The only difference is that now this file will automatically open the linked file in a hidden window and changes to this file's name and/or location can break this connection until you enter Manage | External Data Sources.. and update the connection.
Now i make the connection does it mean that i create a ticket for a specific person only that person will be able to see that info?
It depends on how you have structured your data and what you want to do.
Each record in a table that "belongs" to a given user could have their account name logged in a field, (Let's call it AccountName), in that table. You can then use Manage | Security (Filemaker 11) or Manage | Accounts & Privileges ( older versions ) to limit a user's access to only those records where Get ( AccountName ) = Table::AccountName
You can also write a script that runs when the file is opened to perform a find for only those records that are marked with the user's account name.
You can also use a filtered portal to display just the records that belong to a specific user.
If multiple users can "own" the same record, then you need to use a more sophisticated approach, but this can be done as well.
Do u do freelance work? If so were can i get a hold of u?
Click my forum name and send me a private message. I'll respond with more info and an email address if appropriate.