Locking a table for a single user

[cpe1704tks]

I am creating a sort of question and answer table and I have many fields that are temporary. They gather the information about the user and how they are doing with the q&a. Then the data gets saved to another table. When the user finishes the data stays until a new user goes to the table and all the information gets reset, except for the questions with a script trigger. If someone else comes in the script trigger erases all the personal information and it becomes theirs(as each record is opened). Is there a way to lock the table for only one user at a time?

[bcooney]

CPE, your design doesn't seem solid. Temporary fields? What info are you gathering that you seem ready to discard. Can you describe the interface in more detail. Screen shots? Copy of file uploaded?

That being said, global fields, $vars, etc. may be the tools you need. Are you really using FM7?

[cpe1704tks]

Bcooney,

I am using FileMaker 11 and Windows 7

Can I invite you to a private topic and upload the file there? I am still learning but I have put in a lot of time on this file. I also have a video link showing how it functions.

I will also try to explain better. I am not really discarding the information gathered. This is more like a training tool. The user gets one chance to select the correct answer. The can not change their answer once it has been selected. It is locked down by a calculation in the account profile. The questions get shuffled(randomized using random) every time a user goes to the test table. If the user selects the correct/incorrect answer they get a "You are correct" or "You are incorrect" answer and an explanation of the answer. The information, user name/id, number of questions answered correctly and total number of questions done(which also gets turned into a percentage)gets saved into another table with the user information. The user info page has there name, account, and a portal with the test information. The portal is there so they can take the same test many times. This is to check to see if they are studying properly or not. This is for the user accounts.

The superuser account can go in and modify/add as many questions as he/she likes. They just have to make sure they set the answer comparison field. It matches with the user answer field. If it is not done the user will always have an incorrect answer. The superuser also has buttons to create, delete, change accounts and other things. These buttons are hidden by the filter portal and Get(AccountPrivilegeSetName ).

I also have an admin account which can do everything.

I hope this gives you more information. The table is like a answer sheet paper. You can not have two people using the same answer sheet. They each need there own in order to get scored correctly.

Edited July 16, 2010 by Guest
Made spelling modification

[bcooney]

Just upload a zipped copy here. I cannot promise that I'll have the time to look at this, and others might have better input.

It seems that you feel that you need to dedicate an entire table as an answer sheet. I don't understand why in this table, you cannot create records with the UserID (and/or sessionID). Each user then sees/edits only their records.

[cpe1704tks]

Here is the file. There are 2 accounts available. The superuser and demo. Neither has a password.

Here is a video on how the test is taken and how to add new questions.

This is not a database, this is a test/quiz/survey. Each person has a login, an id, and an info page. The record can only hold 1 id at a time and can only be modified by 1 person at a time. These are FileMaker rules not mine. The id, the user and there score gets recorded each time they enter the record. Then it gets moved to another record. I can not create a table for each user. I will have to create 50 tables all with the exact information.

qanda.zip

[bruceR]

Here is the file. There are 2 accounts available. The superuser and demo. Neither has a password.

Here is a video on how the test is taken and how to add new questions.

This is not a database, this is a test/quiz/survey. Each person has a login, an id, and an info page. The record can only hold 1 id at a time and can only be modified by 1 person at a time. These are FileMaker rules not mine.

FileMaker Inc. is your customer?

[cpe1704tks]

No, If one person is modifying a record then another can not modify it until the first person is finished. I should have said basic database rules incorporated into FileMaker not FileMaker rules. I wish I were at that level. If I were I don't think I would be asking for help, I would be giving it.:

[bruceR]

No, If one person is modifying a record then another can not modify it until the first person is finished. I should have said basic database rules incorporated into FileMaker not FileMaker rules. I wish I were at that level. If I were I don't think I would be asking for help, I would be giving it.

But that is emphatically NOT a Filemaker rule. Well, as far as a single record, yes. But you have made a bad design choice. If multiplie people are taking the survey you design it from the start to be a multi-user system. You are asking to solve the wrong problem. Learn how to immediately make responder records and record the responses there. Note that since you have not provided a full access password we cannot help set that up.

Edited July 16, 2010 by Guest

[cpe1704tks]

account: admin

password: d6eFuqew

[cpe1704tks]

Bruce R can i get you to show me how to make the responder records that match the randomized questions?

[cpe1704tks]

I have lost BruceR. Is there anybody who can show me how to make this work? All ideas are appreciated