I am trying to create a user form is in two parts. First part is
effectively a header consisting of basic details of a job. (order no.
Client , name, time contraints etc) and each entry will be unique.

The second part will ideally be a table to allocate resources against
weeks, with resource names down the left side selected by check boxes,
and week end dates, produced by the dates in the first part across the
top. The table will be populated manually and the data transferred to
a second database.

I also want to be able to retrieve and edit the records on a similar
form.

As I am writing this, I am thinking should I be in Access??

Any help or comments would be appreciated