Form/db set up

[datsyuk]

Hi - I currently have a form with a number of tables but the relevant one to my question is a table that contains a Project, Hours, Skills, and Date Needed. Project and Skills reference other tables. There are other fields within this table but I'll disregard them as they are not relevant to the form I am looking to create. The setup of the form is as follows:

Project (the user can select a project and the information below updates to relate to the selected project)

Current Month Current Month +1 Current Month+2 ...
Skill1 hours hours hours ...
Skill2 hours hours hours ...
Skill3 hours hours hours ...
... .... ... ... ...

The format is similar to a crosstab query with Skill + Date group by Month however you cannot edit a crosstab query. I have queries to group the entries based on the current month and am trying to utilize these in building subform(s?). I just can't seem to get the kind of matrix format that I am looking for. Also, there are a large number of skills and some are only relevant for certain projects.

Any help anyone could give would be greatly appreciated!

Thanks,
Datsyuk

[June7]

Your data is in normalized structure but you want data entry to be not normalized?

Your option is unbound form and SQL INSERT action to save the data.

Review https://www.accessforums.net/access/...orm-25302.html

[datsyuk]

Your data is in normalized structure but you want data entry to be not normalized?

Your option is unbound form and SQL INSERT action to save the data.

Review https://www.accessforums.net/access/...orm-25302.html

Can you go into more detail about using SQL INSERT. I went through the thread on the link you provided and am still kind of confused. What they are trying to do there differs from what I describe in that I am looking for a way to edit the data using the display I describe. I want to group them by month and show the value of hours for each skill across the months. As you said this is not a normalized way to enter data. In this, I will not want the user to have the ability to edit the skill or date (which would require editing my records are once but just the time. I am also open to suggestions for other possibly better ways to go about this but it is not viable to enter them one at a time or in a continuous form as it would be too cluttered and unorganized.

[June7]

Just as code would save new data from the unbound form controls, code would have to populate the unbound form controls with existing data. User edits would be saved to table with sql UPDATE actions.

What you want could get quite complicated.