I have a single table which contains a username and password field, rest of the table is demographics related the to the user. The table is keyed on a standard incremented record number, plus I have index setup in the db on the username. We create the record and input the basic info from a separate full module version, with an administrator login info table . We log into the list module and use the add option to do this.
We have a separate version of the programs with only the edit, list, and export which we have the users log into to update their information in the table. We have the login option setup to allow them to only see and update their own information.
The problem we have is sometime it gets and lists only the one loging in their information for them to edit, sometimes it gets two or more in the list, to edit. The most I have seen is 19 records. The number of records in the table is around 10,000
This is a major problem!
Any suggestions
Thanks
Jim Freeman