DotDragnet
May 23, 2012, 03:47:54 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: follow us on twitter @dotdragnet
 
   Home   Help Search Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Another Database Question  (Read 846 times)
slaughteredlamb
DDN Contributor
Hero Member
*****
Posts: 1089



peakoverload
View Profile WWW Awards
« on: October 15, 2009, 01:07:39 PM »

I hope that this isn't too software specific but again I'm using Filemaker Pro to create a database with several tables.

Table 1: Staff
Records their name, ID, role, date joined, notes

Table 2: Performance
Records any errors made, who made them, when they made it, what projects where affected, the catalogue number, if retraining is needed

Table 3: Training
Records what training was provided, who it was provided, when it was provided

Now thanks to previous help I've entered all my staff into the Staff Table and I can now select their name in the Performance table which picks up the names that were entered into the Staff table.

However I'm now trying to do something similar in the training table but it's a little more complicated. Training can be given to either an individual, to small groups or to everyone. Taking the scenario of everyone receiving training on the same day then in the current set-up I'd have to create a new record in the training table for every member of staff which is going to be rather tiresome! What I'd like to do is to be able to select multiple members of staff from say a drop down list (like that I've created in the Performance table) but once selected I need that selection to be visible on that record and when I produce a report on each member of staff this training is recorded in it.

Any ideas how I'd do that? I can select more than one item in the drop down list I currently have but it only remembers the first one I clicked on when the list closes.

Also I'd like to also have staff listed in this table by name and by role so that if all producers where given training at the same time I could simply select the group called Producers and it would 'update' everyone who is a producer.
Logged
Jeep Stone
Hero Member
*****
Posts: 908



View Profile WWW Awards
« Reply #1 on: October 15, 2009, 04:31:03 PM »

From a data structure point of view, I'd have a join table on Staff/Training:

Training:
id
trainingname

Staff:
id
staffname

StaffTraining:
id
staffid
trainingid

Not sure how you do that in FMP though.
Logged

slaughteredlamb
DDN Contributor
Hero Member
*****
Posts: 1089



peakoverload
View Profile WWW Awards
« Reply #2 on: October 15, 2009, 06:17:18 PM »

Aha Join Tables! Yes just been reading about them online, that certainly sounds like what I need. Can't wait for my copy of Filemaker Pro 10 Bible to arrive! I kinda know what I want to do and how it should work but it's the terminology that stumps me and so I don't know what to search for in the help files.
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2006-2008, Simple Machines Valid XHTML 1.0! Valid CSS!