Hi pplz:
Background: Very capable at Excel, and making a pharmacy program in Access, adapting from my excel idea.
The idea is based around medication packs that we have to pack for customers. It is all "date based", nothing to do with drugs etc
1. Table with all info of customers, packing schedules (weekly, fortnightly, monthly) and doctor details. Done this.
2. New Px and edit Px screens - made these too. (learning off youtube tutorials)
3. - the part im stuck on!
In excel i had a sheet that used macros
It was pretty much:
- Column A: Px names.
- Columns B--> Infinite : Dates that packs were collected by patients (px)
Therefore.
John Smith 1/1/13 7/1/13 13/1/13
etc etc etc
however I dont really know how to get this to work for my current access setup.
Do i create a table that is the same as above (and learn how to make the field fill in as packs are collected.. and a new column is created each time a new pack is taken)
Or do i make a system that creates a new table PER PATIENT that has Column 1: DateID, Column 2 is Date Collected?
I hope that is clear enough... I just thought this would end up creating masses of tables as each customer ends up having their own, but i didnt think having a Table with hundreds of "unnamed" columns that dont really mean anything, just allowing dates in them...
Anyway, im noob but a fast learner. If anyone could give me a kick in the right direciton that would be awesome
Glenn