Problems with query relationships in linked foxpro database tables

  • Thread starter Thread starter K-Towner
  • Start date Start date
K

K-Towner

I've linked a large number of tables (which are from a program named
"FabTrol" and are made with FoxPro). It seems that there are a number of
different relationships between these tables that only exist when queried.
These relationships seem to make sense.
Problem: When I add more than one table in a query and specify the fields
I'm interested in, no information, other than the field headings, is
displayed. The query does work when I only have one table in it.
Does access automatically make relationships between tables in queries if
relationships haven't been setup already?
 
try deleting the relationships that Access creates automatically, and link on
the fields you thing are matched.
 
wow.. or upsize from FoxPro to SQL Server and then just move to ADP.

Linked Tables just plain suck.. they're not reliable or efficient
 
Ok I tried and that didn't work. These also don't give me the option of
enforcing referential integrity either
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linking tables and relationships 3
Relationships for queries 3
Linked SQL Tables don't report Cascading Updates and Deletes 2
relationships 1
Referential integrity and join type 2
Disappeared Relationships; Can't Recreate 2
Object dependencies vs. relationships 4
Relationship must be on the same number of fields with the same... 9

Back
Top