data base with outn relationship

[Guest]

dear friends ,
Is it possible to desin an multitable database with out relation ship
between the tables and extract the datas as i need for calculation from the
tables !?.
if its possible advise how and the drawbacks please .

 

[Armen Stein]

dear friends ,
Is it possible to desin an multitable database with out relation ship
between the tables and extract the datas as i need for calculation from the
tables !?.
if its possible advise how and the drawbacks please .

If I understand your question correctly, yes it is possible to create
a database with multiple tables with no relationships. They do not
need to have defined relationships between them in order to use the
data, though for most cases they should. Relationships help define
and document the structure of the database, and they are also used to
enforce referential integrity.

You can use queries to join the tables together on related fields, and
to perform calculations, even if there are no relationships defined.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com