BOL>Can you give a bit more information please? We dont have nuch idea as to how the system is to work, so before we can give some ideas we need to know what exactly your trying to do!
2 .... ikke ringer ud på samme emne samme tid ???
3 .... derfor hver gang slå det første ledige kundeemne op! ???
Jo Terry - Alle ti sælgere skal hente dataen fra en tabel - HVis der allerede er en der arbejder på et pågældende emne må den anden ikke kunne tilgå dette emne samme - Den skal derfor hver gang findde et emne der ikke er bearbejdet eller afsluttet!!
No need to explain further! I must admit I dont know what to suggest! There are a number of ways this could be done but they all have their good and bad points!
I could ask,when is an "emne" being worked on? Is it when a "sælgere" is looking at it or when it is being edited?
The correct method would be to LOCK a record so that other users cant edit it but they can read it. But if you only want to be able to select from those not already selected then you will need to set a flag in the record´, and it is here where problem can (and will) happen!
Ok terry - Hvis du forstiller dig at det er en telemarketingsvirksomhed, hvor der måske er en 10-20 phonere på hver database - HEr ville det nemeste være for den enkelte leder, at de blot har en liste de skal fylde data i - i stedet for alle 10 - Problemet er bare at de enkelte medarbejdere ikke må have adgang til det samme emne på samme tid - Desuden skal det eksportres til en anden database når emnet er afsluttet - JEg har hørt om andre der har lavet ddet - Men kan ikke få afvide hvordan
There is NO quick and easy solution to this! An idea would be to have a listbox where the user selects from those displayed. In the table a field is updated indicating that this record is no longe available. Then a form is opened showing ONLY that "emner". When this form is closed the flag is updated indicating that the record is now available to others. The listbox could be on a form whic gets refreshed every second or so using the forms timer event. Again this is only an idea there IS room for error, for example two users select the same "emne" at the same time.
It isnt easy to give a solution with an understanding of your requirements and application! Other than the ideas I have given there is not much more I can do
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
