Auto-completion of two columns

[gsdhsadhsadfh]

Hello



I have two tables "Uczniowie" and "zdawalnosc" table "zdawalnosc" is empty and needs to do the query that will help in addition to her.

The problem is that when I needed to just "uczenid" I have used LEFT JOIN and it was on, and now I have two columns which needs thus to add.

When I had a relationship sql script looks like this:

SELECT Uczniowie.*, zdawalnosc.*
FROM Uczniowie LEFT JOIN zdawalnosc ON Uczniowie.Identyfikator = zdawalnosc.uczenid;

but how to do it with two relationships?

[June7]

What is "in addition to her" - what is 'her'?

If you want a compound key, set both fields as PK in the parent table then build relationship that has a link line on both pairs.

I avoid compound keys.

[gsdhsadhsadfh]

Thank you for your response , but further I can not do

https://www.dropbox.com/s/jms64cjw5zauh1s/Projekt%20do%20dyrekcji.accdb?dl=0

This is the file , if you could see it and help me

Table " zdawalnosc_example " and " zdawalnosc_query_example " This is the method that I use.
However, this method allows me to transfer value only " uczenid " . I would like to move through relationship value " uczenid " and " zawodid " or "zawod" ( this is the same )

[June7]

I cannot download from dropbox. If you want to attach here, follow instructions at bottom of my post.

However, advice already given is not altered by the additional information.

[gsdhsadhsadfh]

I'm sorry but I can not attach the file here , it gives me some error.
I will add this file to some other hosting , maybe then it will help


https://drive.google.com/file/d/0B2q...ew?usp=sharing

http://wikisend.com/download/385748/db.accdb

http://p.mnd.io/tWmYKC

https://mega.nz/#!yBdlWC4A!symqztT4s...XIEVNjReABDaig

http://free.mailbigfile.com/9ad7db0d.../listFiles.php


I'm sorry for the way, but the file takes up 6MB.
Thank you

[June7]

Sorry, cannot download from any file share site here and home internet too weak for large files.

Unless you can reduce the file size as suggested by instructions (make copy and remove what is not needed for this issue), cannot help further.

Did you try what I already suggested as a correction?

[gsdhsadhsadfh]

Hello again
I cleaned database , compress , and left quite a small file , I hope that now it will be all right

db1.zip

[June7]

Table relationships make no sense.

Why is zawody table linked to 2 tables?

Non-English makes it harder for me to understand nature of db.

Seems you need a better understanding of relational database principles. Here is a good tutorial site http://www.rogersaccesslibrary.com/