Jump to content

Luis Francisco Rivero

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Luis Francisco Rivero

  • Rank
  • Birthday 11/10/1986

Profile Information

  • Gender
  • Location
    Caracas Venezuela
  • Interests
    Camping, Technology & Range Rovers

Contact Methods

  • Website URL
  1. Yeah, it's mainly a translation issue... My main language is Spanish and I'm developing in Spanish... What I meant is that the skillset will be different for most training sessions. For instance in a rope course training the skills will refer to applied knowledge and techniques whilst on a more general introductory course we will evaluate social skills, etc... With regards to evaluations what I mean is that in a particular evaluation the person in charge will rate the staff member from a scale of 1 to 5 but also record observations, recommendations, etc... All according to the criteria of
  2. The skills are determined arbitrarily during the time a training session gets programmed (usually prior to the selection of participants) only the skills relevant to the training session need to be tested... Evaluations that aren't related to a training session don't test skills and are of a more qualitative nature.
  3. Sorry my bad, evaluations can get triggered by any number of things... Whenever a staff member participates in a training session, his participation will be evaluated in general but also in the specific skills that are related to that particular training session. But also a staff members performance in a project will also be evaluated as well as every once in a while they will get evaluations for extraordinary reasons (not related to a training session, a project or any other foreseeable instance in the database. Hence a separate table for evaluations and participations. Additionally the perfo
  4. All of the skills corresponding to a particular training session have to be tested on every participant. What I want is for the default records to be created so then the trainers can input their measurement through a portal on a layout based on the evaluation table... I think...
  5. I think we are getting there! I'm gonna work a bit on the file before uploading it... I'm not very organized so I'm sure it will look very messy to any one who isn't familiarized with it... I think you raise an important point there... My question still is: how do I pre-populate the competence and evaluation tables with records for every participant of the training session x every skill being measured... Edit: let me rephrase that. Every time I add a skill to a training session a new record should be created in the competences table for every participant and that skill, likewise, e
  6. We evaluate staff member on any number of occasions, one of which is when they attend a training session. But also after they work on a given project or when we see a decrease in performance we call them in to have an interview, etc... So there can be evaluations that are not linked to any training session...
  7. That looks good it's more or less what I had envisioned... The thing is evaluations can happen regardless of the staff members participation on a training session... But I can just create a new TO for that right? Also why would the relationship between participation and evaluations be one to many and I was thinking there should be a join table between evaluations and skills (since you evaluate many skills each time and skills are each evaluated many times aswell.
  8. Your join table should have Many To One relationships to either side. Inventory -< Pack List >- Trip. The logic behind this is that you can pack each item on the inventory many times and you pack many items for every trip. The way you have it set up now you can pack every item on the inventory many times and each time you pack it it is for many trips. The way to fix this is that your Join Table (Pack List) should be related to your other tables through their primary keys (which would be foreign to the join...) Inventory -< Pack List >- Trip _pk_InventoryID -< _fk_I
  9. Ok so I'm developing a database to handle staff management for a Camp that works all year long. So I'm trying to make the following system. We create events training sessions in which staff member either participate or don't (I want to record each time a staff member participates) so this is a many to many relationship between Staff and training sessions mediated by a Participation Table (in which I can create a status field for confirmation, assisted, didn't show up, etc...) but I also want to record each time a staff member gets an evaluation (which is not necessarily during training
  10. You will probably want to change that back since embedding the file makes the data base heavier and slower to handle on remote connections... Another way to go is to have them embedded in a secondary database and point the primary database to that one...
  11. Is the container field Secure? If so I think you are in deep trouble...
  12. Sorry I hadn't notice that part. It is a default script step on FM 13.
  13. Have you tried with: Set Script Animation [off] ? That script step does't work on Windows though (but it won't show an error message). I've never done anything like that but I'd start with that one.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.