Form with "Tick off sheet" with dynamic date columns (eg weeks)

[gangel]

Hey everyone,



I have a table: TbCust (Customers)

I need to record that each customer came into my shop each week.

What I have now is an excel doc:

Cust: 1/1/15 | 8/1/15 | 15/1/15 etc etc etc

Each column has a tick box so when thy come in I just tick and then I can see that each came in each week.

I have no idea how to work this as an access DB..

Obiouvsly I have a customer table, but should I have a Field for every single date for that patient...? and just create those columns at the start of the year?

That seems COMPLELY wrong.

What im thinking is I should have a table with dates going down (the Monday of each week of the year) and then having some kind of linking table ....

But then I don't know how to disply this kind of cross tab linked table for the check boxes?

Its like a subform for each detail....? Showing only the most recent 4 weeks?

Wow that was my brain going all over the place, but let me know if you have opinions/ideas I'm keen to learn how to do this!

[June7]

Access tables and queries are limited to 255 fields.

A record for each visit (dates going down) would be a normalized data structure. However, your idea for a 'checkboxes' data entry form is impractical.

Maybe this tutorial site will help http://www.rogersaccesslibrary.com/