473,624 Members | 2,577 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Document Tracker

I'm in the military and creating a database to track awards. I need to

create a document register where the award can be tracked if it were to

leave the office and go back to the recommender for corrections or come

back.
Basic Lay out would be
Main Form: Name, SSN, Recommended Award, Company
Subform: Date Received, reason received, Date Out
Problem is when I have to enter an award for the same person but for
different circumstances, the subform will show the same data on both
awards. I need it to be separate.
Thanks

Nov 13 '05 #1
2 2214
sounds like you need to differentiate the awards.

Person--(1,M)---WinsAward---(M,1)---Award

WinsAward--(1,M)--AwardMovement (Subform)

WinsAward would have its own unique ID (maybe an autonumber) and then
you could link that field to "AwardMovem ent" or whatever - the
individual award/documentation being shipped back and forth. And the
last record should be the current location of the award.

Nov 13 '05 #2
In the military we use SSN's I know this is an issue with some, but
this is how Soldiers are tracked due to the number we have.

My solution was to create an AwardsID on my main and subform. I then
indexed it and allowed duplicates. I did the same thing with the SSN.
Now when I add an aditional award on a Soldier the subform duplicates
the AwardID on the main and subform allowing it to be separated from
the first award submitted.

So everytime I click on a different award for a Soldier I see only the
history of that award, thus creating and effective document tracker.

Thanks

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2181
by: Jerrykhan | last post by:
Hello, who know the best Bug tracker system on a Python/Zope server ? BugZilla is Perl oriented (beuh !!) What about others ? Is A python oriented BugZilla like exists ? or need I write it ? On a zope one or behind an apache one. Any ideas ? Thanks ..
1
3261
by: jcharth | last post by:
Hello, I thought there was an issue tracker that came with ms access but i was wrong. does anyone know where i can get one. Or should i just make one.?
0
1750
by: Stephen Walther | last post by:
Microsoft has released the final version of the ASP.NET Issue Tracker Starter Kit. The Issue Tracker Starter Kit is a free application produced by Microsoft which illustrates best-practices when building ASP.NET 1.1 applications. Both VB.NET and C# source code is available for download. The Issue Tracker works with both Microsoft SQL Server and Microsoft Access. You can download the Issue Tracker Starter Kit (including all source code)...
158
6352
by: Giovanni Bajo | last post by:
Hello, I just read this mail by Brett Cannon: http://mail.python.org/pipermail/python-dev/2006-October/069139.html where the "PSF infrastracture committee", after weeks of evaluation, recommends using a non open source tracker (called JIRA - never heard before of course) for Python itself. Does this smell "Bitkeeper fiasco" to anyone else than me? --
1
1595
by: bcannon | last post by:
At the beginning of the month the PSF Infrastructure committee announced that we had reached the decision that JIRA was our recommendation for the next issue tracker for Python development. Realizing, though, that it was a tough call between JIRA and Roundup we said that we would be willing to switch our recommendation to Roundup if enough volunteers stepped forward to help administer the tracker, thus negating Atlassian's offer of free...
1
1707
by: zig158 | last post by:
I am in the early stages of creating a Hamachi like peer-to-peer VPN application that has the ease of use of Hamachi with the flexibility of OpenVPN. Hamachi is nice but is to limited and not open source. OpenVPN is overly complicated to set up for the home user. I hope to fix that. It is pointless to reinvent the weal, so I plan on letting OpenVPN do all the heavy lifting. My application “only” has to connect to a rendezvous server of some...
0
997
by: Brett Cannon | last post by:
On August 23rd Python will be moving off of SourceForge and over to our own issue tracker run on Roundup (http://bugs.python.org/). During the transition there will be a time where the SourceForge tracker is no longer being used but that the new tracker has not been brought up yet. We expect this gap to be for a few hours. But to minimize issues, please try to avoid using either SourceForge or the new issue tracker on Aug 23rd if you...
0
1069
by: Sells, Fred | last post by:
I've been tasked with either implementing Request-Tracker to upgrade our help desk issue tracking system or finding a Python equivalent (both in terms of functionality and wide spread use). Request-Tracker uses Apache and MySQL, which would also be appropriate to Python. I would prefer to go the Python route, especially since Request-Tracker is written in Perl (which I don't know). My initial attempts with Google were not useful due to...
0
1170
by: M.-A. Lemburg | last post by:
On 2008-04-29 22:15, Sells, Fred wrote: You should have a look at Trac (http://trac.edgewall.org/) and roundup (http://roundup.sourceforge.net/). Both are written in Python and provide excellent issue tracking. They differ a bit in design and approach to issue tracking, so you will likely need to investigate a bit further before you decide. Both are easy to extend and adapt to whatever needs you have.
0
8249
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8179
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8633
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8348
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7176
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6112
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4084
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4187
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1797
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.