relationships

A

angie

i have a table that is based on a query (based on another table). i have a lookup field and the relationship i am seeking is one-to-many. can i define relationships between a query and a table or should the relationship be between the original table and the new table ignoring the query the new table is based on?
 
S

solex

Angie,
Your table relationships should be defined using the Database Relationship
Tool. this serves two purposes (1) The database can handle some of the
structural integrity w/o you having to code it and (2) it is a means of
documentation.

Other then that you can define any join type you want when building a query
regardless if you are joining a table or a query.

Does this help?

Dan

angie said:
i have a table that is based on a query (based on another table). i have a
Click to expand...
lookup field and the relationship i am seeking is one-to-many. can i define
relationships between a query and a table or should the relationship be
between the original table and the new table ignoring the query the new
table is based on?
 

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

Save as word to xml is splitting place holders ex: $abc.xyz$ 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Append Crosstab Query to Existing Table 0
Creating a Chart on form from selected data in query. 0
Adding data to MS Access from csv file 0
List all tables, including document structure 0
Setting column width in a table with a macro is not working 0
Excel does not accept text format! 0

Top