Skip to Content
author's profile photo Former Member
Former Member

Database Design

Post Author: Horizon57

CA Forum: General

I have the oppertunity to design this Access database for the specific purpose of storing the summariized data going into the report as well as making the most efficient design to support user prompts in the report involving a dynamic cascading pick list.

Three fields (lets call them A, B and C ) are common to all the tables in the database and will be used in the cascading pick list to garner user input and drive record selection at the mainreport level.

Database Design Question:

Is it beneficial to have a table in the database which contains only fields A, B and C to create the parameter values for the pick list. This table would then be joined to each other table in the database on a primary key field (A). This is as oppoesed to having an db with unjoined table and writing record selection formulae for each table within the crystal report.

I would love everyones opinion. An yes, I am working without CR Server and a SQL database. This is a proof of concept exercise to justify the possible future expenses of a similar reporting system. Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 06:30 PM

    Post Author: jeffatncx

    CA Forum: General

    How will the data in all these tables be maintained? If a new value is added to col A, B or C, will this be done across all tables at once?If so, I would write query to select the three columns desired for the list of parameters. If all tables are the same, just pick one (table) arbitrarily and select from it. I don't see any need to add another table that will then need to be maintained.Jeff

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.