hi all,
I m an Access newbie, this might be a trivial question.
I have three tables.
1. Projects table
2. Programs table
3. Programs Vs. Project table - multiple projects can be associated to programs by a percentage.
Format of this is: Programs | Project | Weight(in percent)
I need to create a Form to enter in data for the Programs Vs. Project table, My boss wants the form in the following format:
Program 1 Program 2 ....... All Programs
Projects 1 Weight (1,1)
Projects 2 Weight (1,2)
.
.
All projects
This means a table with all the programs listed horizontally on top, all projects on vertical on teh sides, and he can go in and enter all the weights for all projects at once.
This might be trivial the experienced programmers in this forum, but as a newbie, I have no idea to do this kind of form. I've been using the wizards to generate forms.
Can someone help me get started ? Thank you all in advance for your time.
I m an Access newbie, this might be a trivial question.
I have three tables.
1. Projects table
2. Programs table
3. Programs Vs. Project table - multiple projects can be associated to programs by a percentage.
Format of this is: Programs | Project | Weight(in percent)
I need to create a Form to enter in data for the Programs Vs. Project table, My boss wants the form in the following format:
Program 1 Program 2 ....... All Programs
Projects 1 Weight (1,1)
Projects 2 Weight (1,2)
.
.
All projects
This means a table with all the programs listed horizontally on top, all projects on vertical on teh sides, and he can go in and enter all the weights for all projects at once.
This might be trivial the experienced programmers in this forum, but as a newbie, I have no idea to do this kind of form. I've been using the wizards to generate forms.
Can someone help me get started ? Thank you all in advance for your time.