I'm building a database that multiple users will be able to log into online. I've created a table for users. Each user has a unique ID#. I've then created related tables using their ID# as the related field. How do I make it so when a user logs into the database, it recognizes the user and allows them to only work within their ID#?

Thank you in advance - Jon

What do you mean by only allowing them to work within their ID? Do you mean they can only see certain layouts? Or do you mean there is data in the DB to which they should not have access?

yes on both fronts... the users are real estate brokers and they will only be allowed to work with / view their own specific (related) clients. also, i need to limit them from accessing some layouts but i think i know how to do that in the Accounts & Privileges area. Thanks - Jon

This is how I do it with my Filemaker BMS. I have global records named account_id, account_uname

Now, I relate all the users records to the global field. So, the user will only see records related to their ID.