HalcyonDaze
New member
- Local time
- Yesterday, 23:08
- Joined
- Aug 12, 2010
- Messages
- 8
This may be more of a Table issue than a Report Issue, but the Report is the final goal. I need to create a report that pulls from 3 separate tables.
Table A has a large (several hundred) list of instruments being used in a project. Table B has a list of spec sheet categories that are different for each type of instrument (60 max). Table C has the actual values for each instrument that would populate those categories.
The report needs to have a single page for each instrument, with the correct categories (Table B) populated into one column on the report, and the actual values for each instrument (Table C) populated into the other, It will also have to display Tag/Description/Location info from Table A.
I have no idea how to properly set up the database to allow this (something with table relationships I think?). Any thoughts?
PS its Access 2007 running on WinXP sp3
Table A has a large (several hundred) list of instruments being used in a project. Table B has a list of spec sheet categories that are different for each type of instrument (60 max). Table C has the actual values for each instrument that would populate those categories.
The report needs to have a single page for each instrument, with the correct categories (Table B) populated into one column on the report, and the actual values for each instrument (Table C) populated into the other, It will also have to display Tag/Description/Location info from Table A.
I have no idea how to properly set up the database to allow this (something with table relationships I think?). Any thoughts?
PS its Access 2007 running on WinXP sp3