Noobie needing some help on how to make this "idea" work!

[gangel]

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

[June7]

Why would the Excel macros create a column for each date?

Consider table/fields structure:

tblPacksDistributed
ID
CustomerID
DatePickup

[gangel]

Thanks for the response June.
Using the above method, it would only record the most recent pickup date... But i want to keep a catalogue of reference so i have a record of every single pickup date for that customer.

[June7]

There would be multiple records for each customer. For every customer pickup enter a new record with that customer ID and the date.

[gangel]

Ahhhh that makes so much more sense, So

ID CustID DatePickup

Goes down like that then i can query and report from that for specific customers...

omg brain epiphany Thanks June, appreciate that.

ill have a crack at making it and see how i go