TOUGH QUESTION:Can a query create a relationship between two tables?????

[Accessghostrider]

Hi Everyone

I run 2 make table queries and want them to have a relationship afterwards.
it doesn't have to enforce referntial integrity as i only need to view the
fields of the other table.
Also i run these queries everyday so new tables are produced everyday and the
relationship has to be severed before the query is run.
So is there a query that can delete a relationship from 2 tables aswell?

Cheers

 

[Klatuu]

I would suggest an alternative approach. Rather than use make table queries,
create your tables and relationships with the correct data types and lengths.
Make table queries are pretty sloppy as to assigning data types and use the
predefined default field size for text fields that may be wasting memory
space.

Then just use append queries to load the tables.

 

[Guest]

A relationship is used to enforce referential integrity.
For this to be done, it is necessary to index the related fields.

Unless you need to enforce referential integrity, there
is no need to define a relationship.

Unless you need an index, there is no need to define
an index.

Of course, you don't need to define a relationship for the
fields to be related.

(david)

 

[Accessghostrider via AccessMonster.com]

Basically all i want is to view fields from a record that is in another table,
how can i do that?

Cheers

A relationship is used to enforce referential integrity.
For this to be done, it is necessary to index the related fields.

Unless you need to enforce referential integrity, there
is no need to define a relationship.

Unless you need an index, there is no need to define
an index.

Of course, you don't need to define a relationship for the
fields to be related.

(david)

Hi Everyone

[quoted text clipped - 6 lines]

Cheers

 

[Accessghostrider via AccessMonster.com]

Basically all i want is to view fields from a record that is in another table in the main table,
how can i do that?

Cheers

A relationship is used to enforce referential integrity.
For this to be done, it is necessary to index the related fields.

[quoted text clipped - 15 lines]