Relationships

  • Thread starter Thread starter John Sheckles
  • Start date Start date
J

John Sheckles

First, I will like to thank whoever is able to help me
with this issue. I have searched the online newsgroups,
and have not found the answer to this question, so I
thought I would ask it. I am a newer Access 2002 user and
have come up with an issue with Relationships (I think)
that I am not able to figure out.

I have built an access database with 5 tables. Each table
has unique data for support for online selling at Amazon.
They have data files that you are able to download (with
data), so I created a table for each of the 4 downloadable
files with the same field names as the file headers. The
data import works well, and have no issues with the data.
I created a 5th table for out going postage information
(Amazon does not supply that data).

The discovered the issue when I wanted to build query's
from more than one table, but only if I wished to include
the out going postage table. I have deleted and recreated
the outgoing postage table, as well as all relationships
between the tables.

The issue I am seeing, is if I create a query and only
want to use data from the out going postage table, the
query work correctly. If I try to add a field from ANY of
the other tables, I see NO data in the query. Therefore I
am guessing I have issues with the relationships between
the out going postage table and the other tables. I have
no issues in creating query's between the other tables, as
long as the out going postage table is not involved.

I have checked to insure the key fields in each table are
the same (field size, properties), and the issue remains.
Any help that anyone could give me on this issue, would be
greatly appreciated.

Regards,

John Sheckles
 
I would think that the problem is more likely to lie in the Join you used in
the Query Builder between the other table and the postage table. Just to
make sure the Relationships are not somehow intefering, delete any
Relationships from the Postage table to any other table. Then create your
Query, click and drag the corresponding field to the Postage table to create
a Join, click the join line to highlight it, then right click it, choose
Join properties and pick the one that is correct.

If that doesn't work, then you may need to post the SQL for that Query, and
tell us the exact results.

Larry Linson
Microsoft Access MVP
 
Hello, and thank you for taking the time to help me with
my issue.

I deleted the relationship to the postage table. I then
went into the query wizard and started to build a simple
query. I selected all fields from the postage table, and
one from the sold listings table, and clicked ok. I then
received the following error message.

You have chosen fileds from these tables; shipping and
sold listings; one or more of the tables isn't related to
the others. Click ok to edit system relationships. You'll
need to restart the wizard. Click cancel to return to the
wizard and remove some fields.

Thank you once again for your help.

John Sheckles
 
Back
Top