Solved Creating a db thoughts

[arnelgp]

if you don't have relationship, just create the query and "join" them on PK/FK
just like i did on the demo.

you can also create the relationship on the other db, only if you like.

 

[isladogs]

Relationships should be done in the database containing the tables. In your case, the backend.
if you apply relationships in the frontend, they are purely 'cosmetic' and referential integrity cannot be enforced.

 

[GPGeorge]

I opened up to review your relationships. I don't have the MSys relationship stuff.....what is that? I created the relationship around the DataEntry only.

Tables with the prefix MSys are hidden system tables. You can see them if you elect to show them.

 

[Pmetro]

FANTASTIC.....thanks so much for your assistance. I went through your queries and I found what I was missing. I created a relationship...then added the description to the query and it worked like a charm.