Help needed in table design (1 Viewer)

[jayanth1808]

Hi all, I am preparing a database where i need to have a table to enter forecasted hours per each week for all associates ( there is another table with list of all associate names ). And also i need a form to enter weekly details into the table.

Please share if you already have any database with such table which would store weekly data.

Thanks in advance.

 

[BrettM]

We are here to assist you with problems you might be having with your own code... not write the stuff for you!

Try paying a consultant to do it.

My rates are $120 per hour if you are interested.

 

[Mr. B]

Jayanth1808,

Try creating a table with fields for each of the items you know you will need about each forecast record. Like the Associate (foreign Key to your existing table), number of hours and the date or week to which it applies. Once you have this table, you can make the relationship between the two tables. You would be able to then create forms that will allow for the data entry into the forecast table for a selected associate.

As you work through this, just post back here for more info as you need it.