array of DateTime in design view

[lorenb]

Hi,
I'm using the design view in order to construct my DB.


I would like to have a column which will store several DateTime data types (actually an array would have been good). How can it be done??

Thanks,

[HiTechCoach]

Hi,
I'm using the design view in order to construct my DB.
I would like to have a column which will store several DateTime data types (actually an array would have been good). How can it be done??

Thanks,

I think what you want is a child/sub table where each date is stored in a separate record.

[lorenb]

Thanks HiTechCoach,
Please let me get elaborate a bit. I have a table where I store all my selling, where I have a column of repayment date. Until now, no problems as all customers payed via credit card in one payment. Now, I want also to enable paying via Checks (several payments for 1 product. Max 3 payment). Is your solution consist of dynamically building a table of dates and store all dates there? This will create a lot of tables even for customers which pay in 1 payment. Is it "OK", if I just add to my existing table 2 columns say: "Payment 2", "Payment 3"?

Thanks

[HiTechCoach]

Is your solution consist of dynamically building a table of dates and store all dates there?

I am not suggesting anything dynamic or storing q list of possible dates to pick from.

I use a date picker form.

This will create a lot of tables even for customers which pay in 1 payment. Is it "OK", if I just add to my existing table 2 columns say: "Payment 2", "Payment 3"?

You only need to create ONE new table that holds all the payment related to the current table that already has the one date. You will need to move the data for the current one data to the new tabe. I owuld use an append query.

Here is a very simple example where one payment is applied to only one invoice.

Table: tblPayments
Fields
PaymentID (autonumber- Primary Key)
Payment_OrderID ( long - foreign key - links back to Invoices)
PaymentDate (date/time)
Payment Amount (currency)
PaymentType (long - use a lookup table for check, Credit Card, etc)
PaymentReferenceNumber  (text - store check number or CC number)