Is there a way to limit access to certain records based on the logged in user?

Example: I have a grade database with 2 sections of a course. How can I give 1 TA access to one of the sections and a second TA access to the other section, without having to worry about 1 TA changing the other's grades?

In the access privs setup you can limit the <whatevers> that a user has access to.

Account & Privledges -> Privledge Sets -> Make of Privledge Set for each type of access.

Edit one of the Priledge Sets -> Under Data Access & Design, click on the Records drop down and change it to Custom Privledges.

You can now edit any of thier abilities for any or all tables. To create a custom ability via calculation...click on a table -> click on any of the Set Privledge options and select "limited..." This will allow you to define thier priv via calculation, for instance "Section# = 2".

Excellent! I knew it had to be something simple. Thank You!

OK, how do I do this (restrict access to certain records based on the user) in FileMaker 6? I have 8 or 9 users and we all have access to the same "contacts" database. However some of the contacts are "personal" or "private" for some individual users. Others (most of them) are general contacts that can be accessed by all. I currently have a field with a dropdown that indicates which user the current record belongs to. With one of the options being "ALL". Is this the correct way of going about it? AND (to re-cap my question) how do I setup limited access to records based on the user login in FMP 6?