Tablelink via KeyField deletes Values i Need. (exclude)

[alexander__]

I have a table in which I create a Composite key . This would be my main table , here are more data than in the second table which also owns the composite key . Once the two tables are connected via keys in the data model , the items are only available , which occur in both tables . I would but the entries from my main table also need if for this key in the second table , no entries are available for this . How can I make this?

MainTable                    2nd Table

Eintrag1                              Eintrag1

Eintrag2

Eintrag3                              Eintrag3

i need Eintrag2 although it is not in Table2.

Actually i got only this

MainTable                    2nd Table

Eintrag1                              Eintrag1

Eintrag3                              Eintrag3

[shree909]

How your joining the tow compoiste keys, if your making outer join then it should work.

can you share the app to dig into it.

[maxgro]

I think you can show all the items, also the items in one table

See the attachment or post a small example with your problem