Greetings! I am creating a file for Misc. Work Requests. We currently are using a 3 ring binder and hard copies of everything. With this solution, we will move it to totally electronic, and much easier to maintain.

We are using FMP 6, and I have one table, called MWR. It is basically all of the info to be collected, plus all of the reports to be generated from the data.

In this file, on one of the layouts is an area for "Salesman" and their mobile number. We will have up to 15 users accessing this file, and not always from the same computer, so they'll each have their own login/password that will give them access. I under stand about groups and access, but I was wondering about how to fill in the info into the salesman and mobile fields. What would be the easiest way to do this? A simple value list won't work. I'm sure that I haven't given enough information, so if you ask me what else you need, I can tell you that way.

Thank you.

Donnie

Create a table which has all of the Users in it

Make sure you have

Login: this is the same as the username login for gaining access into the database

Full Name:

Moblie:

etc

On your main table you can create a script that creates a new record and set field(main table::login, get(currentuser))

create a relationship between this table and the users table based upon login from both files

In the main table, make the full name and mobile fields be lookups from the user table based upon this relationship and it will fill in all the information that you require.

thant'll do it!