User 'only' record to be created

[Matt Limb]

Can this be done? I have tried variations all afternoon with no success.

I want a table that has one record for each user only – the record being created when the user account is opened and deleted when the account is closed. Each user can only see his or her record. The table, and respective records, are to open when the application starts and the user logs on.

The idea being that the layout will act as a ‘main menu’ with various buttons for scripts etc plus a text fields in which the user can add notes & reminders – which will only be accessible to them and part of the ‘larger’ application.

It looks like it should be possible but I have had no luck so far.

Thanks in anticipation.

[Zero Tolerence]

What do you mean by when the user account is opened and closed

[Ender]

Use a User table, where each record is one User. If you keep the users' account name in the User record, you can set a global gAccountName, and simply use a Go to Related Record [ Show only related records ] script step to jump to that user's record.

[Matt Limb]

Sorry, when the user account is created or delete is what i mean