Creating the relationships in the database does not change how the recordsets will be created.
The way you create relationships in the application is through the use or Foreign keys to relate to primary key columns.
when you do this, you need to manually modify the recordsetrs that are created to retrieve the related information using join queries, this will not be done by the DataAssist wizard.
more information on creating join queries can be found here:
sql_join.asp