Account Names & Relationships

[bret10]

I am creating a database to enter timecard information. I have a table for the timesheet and a table for user account creation (for use by my supervisor for creating new accounts w/o knowing the program) the account table creates accounts and store user/pass info.

I want to have individual accounts for each employee so they can only access their timecard info. In the timesheet I have the FM 8 get the account name of user and assign it to their timecard. I can get the account name into the employee field, but I want to have FM 8 replace the user name with the cooresponding name of the employee. It would seem that I could do that with relationships, but i do not know how.

[mr_vodka]

See here.

http://www.fmforums.com/forum/showtopic.php?tid/196670

You could also use record level access to only display the current user's records. Do an advanced search for +record +level +access

[bret10]

Thanks for you help, an excellent suggestion. However I cannot find where you can have an account view only records for that name. the privileges area does not seem to to have that option?

[Vaughan]

You create a calculation that defines what the access is dependent upon.

It'd be something like:

CreatedBy = Get( AccountName )

... where the CreatedBy field contains the name of the account that owns the record.

[bret10]

That will work great... Next...

I want to have two tables, one for accounts and one for employees. the accounts is for making new accounts, so I want to be able to make an account then choose a name from the employee table as a value list. in the employee table I want to put a field saying which account that name is a associated with.

Account Table:

field 1

username field,

field 2

name from employee table

Employee table:

field 1

employee name,

field 2

cooresponding user account

Edited July 17, 2008 by Guest