relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top