D
Dee
I have a "Projects" table similar to an "Orders" table that has project
Items. When I first built this database, I couldn't figure a better way to
do this, but I'm hoping someone can help figure out a better way. I have 1
projects table with 10 items tables. The reason was I could not figure out
how to have each section have a section header of its own.
The quote must be able to have up to 10 sections (more if neccessary) with
their own section headers and comments for each section when neccessary.
Not all sections will have section headers and not all will have comments.
I put the section headers and comments for each section in the Projects
table so they would only appear once. I can't put them in the Items tables
because it would have to be repeated several times. I tried creating a
section table, but then items that didn't have section headers wouldn't
appear in the query. I would prefer to have 1 items table and have the
capability to have section headers and comments sections without having to
have 10 subreports (especially since I can only put 7 subreports in a
report). Each section starts over the numbering of the line items beginning
with 1.
What would be the best way to accomplish this? Can I have a projects table
with only one items table and how would I relate that with section headers
and comments that would only appear above (section headers above) and below
(comments below) their respective sections without having so many tables and
subforms/subreports? Having so many subforms makes data entry more
difficult and printing entire quotes more difficult.
Please help
.
Thanks,
Dee
Items. When I first built this database, I couldn't figure a better way to
do this, but I'm hoping someone can help figure out a better way. I have 1
projects table with 10 items tables. The reason was I could not figure out
how to have each section have a section header of its own.
The quote must be able to have up to 10 sections (more if neccessary) with
their own section headers and comments for each section when neccessary.
Not all sections will have section headers and not all will have comments.
I put the section headers and comments for each section in the Projects
table so they would only appear once. I can't put them in the Items tables
because it would have to be repeated several times. I tried creating a
section table, but then items that didn't have section headers wouldn't
appear in the query. I would prefer to have 1 items table and have the
capability to have section headers and comments sections without having to
have 10 subreports (especially since I can only put 7 subreports in a
report). Each section starts over the numbering of the line items beginning
with 1.
What would be the best way to accomplish this? Can I have a projects table
with only one items table and how would I relate that with section headers
and comments that would only appear above (section headers above) and below
(comments below) their respective sections without having so many tables and
subforms/subreports? Having so many subforms makes data entry more
difficult and printing entire quotes more difficult.
Please help
.Thanks,
Dee