Ok I am looking to put together a data base to be used in the stargate game for holding things like mission briefings and reports and also personnel records
( Read more... )
Putting something like that together would be fairly easy in some form of SQL or access.
Can probably do it in one DB just have two sets of tables, that way you can assign personel to missions.
If you want to restrict access, best way i can think of is to produce a front end login setup that allows you to restrict who sees what based on login.
Shouldnt be that difficult to produce. Just need to work out what info is needed, the table structures, the access limitation and then stick a front end on it. Did very similar stuff at uni.
oh you are so much more knowledgeable than me want to help?
I was thinking of using access. currently waiting on getting the info from the organiser which will give me the format for the missions as they give me the old briefs I can then decided what additional fields I want. I can see it getting horribly complex as it could include a database of materials recovered and so a system to check them in and out.
Also it can just run on my laptop but I assume it is also easy to make it run across a local network if we set one up?
restricting user rights is not a major issue as it may well be just on my pc and so I can control it by that but it would be nice to allow other people to type up mission reports.
Comments 4
Can probably do it in one DB just have two sets of tables, that way you can assign personel to missions.
If you want to restrict access, best way i can think of is to produce a front end login setup that allows you to restrict who sees what based on login.
Shouldnt be that difficult to produce. Just need to work out what info is needed, the table structures, the access limitation and then stick a front end on it. Did very similar stuff at uni.
Reply
I was thinking of using access. currently waiting on getting the info from the organiser which will give me the format for the missions as they give me the old briefs I can then decided what additional fields I want. I can see it getting horribly complex as it could include a database of materials recovered and so a system to check them in and out.
Also it can just run on my laptop but I assume it is also easy to make it run across a local network if we set one up?
Reply
Reply
Reply
Leave a comment