Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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