Relationships are simple! If you create a relationship, you then must decide
whether or not to enforce referential integrity. If you enforce referential
integrity, then you must decide whether or not you want cascade update and
cascade delete.
Your problem more likely has to do with good design of the tables structure for
your database. You need to do some studying of the principles of normalization.
--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com
· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel