May 23, 2012, 03:47:31 PM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
: follow us on twitter @dotdragnet
Home
Help
Search
Login
Register
DotDragnet
>
The Tech Side
>
Tech stuff
>
Another Database Question
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Another Database Question (Read 846 times)
slaughteredlamb
DDN Contributor
Hero Member
Posts: 1089
Another Database Question
«
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
Re: Another Database Question
«
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
Jeepstone
slaughteredlamb
DDN Contributor
Hero Member
Posts: 1089
Re: Another Database Question
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> General Discussion
=> Jee's Forum of Appalling Jokes
-----------------------------
The Creative Side
-----------------------------
=> Arty stuff
=> Photography
=> On the web
-----------------------------
The Tech Side
-----------------------------
=> Tech stuff
=> Hardware & Software
-----------------------------
The Business Side
-----------------------------
=> Anything business related
-----------------------------
The Practical Side
-----------------------------
=> Practical Advice
DotDragnet
>
The Tech Side
>
Tech stuff
>
Another Database Question
Loading...