No relationships created in Db?

[LaurelLee]

I am learning the ins and outs of a database which I know nothing about(new job). I wanted to analyze the relationships between the tables to gather information about how this thing is put together, and there isn't one relationship created! In my training, I have always been taught to create these relationships when creating the tables. My question is this: Should I attempt to figure these out and map them? If so, will this have any effect on any of the code modules? Thank you all for your help!

LL

 

[Golom]

It will probably have a substantial effect on your understanding of the database. You can define relationships in the "Tools/Relationships" window without impacting your application by leaving the "Enforce Referential Integrity" box unchecked. If you place a check mark in that box then Access will attempt to verify that the defined relation is valid. If you have also defined cascaded deletes and/or changes then you could be changing data in your database ... probably not something you want to do while you're experimenting. If no relations have been defined that probably means that the earlier programmers choose to enforce referential integrity in code or (shudder) just hope that everyone knew the rules and didn't bother to enforce it at all.