relational data base design

[PRIMENOVICEORDUMMY]

i HAVE CREATED 4 TABLES WITH NUMBERS UNIQUE IN THE FIRST COLUMN

NOW SOMEHOW THE TABLES ARE NOT RELATIONAL SO THAT QUERY FOR A REPORT DOES
NOT SEARCH ALL THE TABLES.

I CAN SEARCH EACH TABLE SEPARATELY FOR ALL CLIENTS WITH WHOM WE HAVE DONE
SPECIFIC WORK AS CODED ON A SPECIFIC FIELD ENTITLED "MATTER", BUT IT RETURNS
ONLY THE CLIENT NUMBERS FROM THAT TABLE AND NOT THE CLIENT NAME AND ADDRESS
THAT MATCHES THE NUMBER AS SET UP IN A DIFFERENT TABLE.

IN OTHER WORDS THE QUERY AND REPORT THAT I DO IS NOT CORRECT OR THE 4 TABLES
DO NOT RELATE TO EACH OTHER SO THAT THE REPORT WILL CONTAIN ALL FIELDS AND
CLIENTS THAT MATCH THE QUERY.

PLEASE RESPOND VIA EMAIL TO (e-mail address removed) HELP!!! AND PLEASE BE
SPECIFIC AS I AM NOT A NERD OR GEEK OR OTHER TECHIE.

 

[Larry Daugherty]

Please find the Shift key and make appropriate use of it when you
re-post. Prose in all upper case is considered to be SHOUTING!

As for email demands, You post them here, we'll answer them here.

HTH

 

[Philip Herlihy]

i HAVE CREATED 4 TABLES WITH NUMBERS UNIQUE IN THE FIRST COLUMN

NOW SOMEHOW THE TABLES ARE NOT RELATIONAL SO THAT QUERY FOR A REPORT DOES
NOT SEARCH ALL THE TABLES.

I CAN SEARCH EACH TABLE SEPARATELY FOR ALL CLIENTS WITH WHOM WE HAVE DONE
SPECIFIC WORK AS CODED ON A SPECIFIC FIELD ENTITLED "MATTER", BUT IT RETURNS
ONLY THE CLIENT NUMBERS FROM THAT TABLE AND NOT THE CLIENT NAME AND ADDRESS
THAT MATCHES THE NUMBER AS SET UP IN A DIFFERENT TABLE.

IN OTHER WORDS THE QUERY AND REPORT THAT I DO IS NOT CORRECT OR THE 4 TABLES
DO NOT RELATE TO EACH OTHER SO THAT THE REPORT WILL CONTAIN ALL FIELDS AND
CLIENTS THAT MATCH THE QUERY.

PLEASE RESPOND VIA EMAIL TO (e-mail address removed) HELP!!! AND PLEASE BE
SPECIFIC AS I AM NOT A NERD OR GEEK OR OTHER TECHIE.

Your question reveals to any experienced eye that you are entirely
clueless about database design. That's ok - everyone here was once in
the same position, but you have quite a hill to climb. You should find
a book on the basics of relational database design - most Access books
will have a section on this. You need to understand what a "foreign
key" is, and when you do, the penny should drop. Database design needs
understanding, and your life will be miserable if you don't get the
basics under your belt.

However, it's just possible from where I'm standing that you have four
very similar tables, containing very similar data in a very similar
structure. If that's the case, you should combine the tables into one,
and use a further column to contain the information that made you want
to split the data into four tables. Meanwhile, as a quick fix, you may
be able to use a "Union" query to draw together information from all
four tables. You'll need to look that up.

I hope that helps, and you're not in fact a troll.

Phil, London

 

[John Spencer]

You need a query to join the tables together.

Open a new query
Select two tables
Drag from the the unique field in table 1 to the field in table 2 that
corresponds to the unique value. This should draw a line between the two tables.

Select the fields from the two tables that you wish to see.

Run the query and use it to get the information you need.

Tables - store data - they are not the place to enter data
Queries - get data from tables, order the data, and filter the data
Forms - display data and are the place to enter data
Reports - print the data.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County