I need to produce a tracking database for part of the local health authority. Initaly it will be a simple database of names and addresses and activitys partaken, This will be manually entered. However they are wanting sometime in the next 12-18 months add the functionality of a swipe card/barcode system so that each patient is issued a card and when they enter the building it is swiped and the database is updated to show who visited when. The same will apply to each activity. This will then be used to produce demographic reports as to who attended when and what facilities they used each time. Any help or recomendations on how to proceed with this would be very gratfully recieved.
Version: v6.x