Issue with join and related data

[miki]

Hi guys,
I need some clarifications.
I have a table Suppliers and a table Articles with a field "suppliers" as foreign key.
I would like to have a lot of articles referring to a single Supplier.
So in a list that I called "Suppliers Arts" (referring to Suppliers table) i set a join and related data.
Now in my web site inside my Suppliers list, I can click on add a new article and a form appears (in a popup). And that is what really I want!
BUT, as in the attached picture, in the form appears another add button (it seems recursively?).
Is there any settings I can change to fix this?
Thank you,
Michele

 

[cheesegrits]

You can turn that off under the form's options, "Show related data links".

-- hugh

 

[miki]

Thx hugh,
it works.

One more question with the same focus.
Now I add a Supplier with no related articles.
When I see the Suppliers joined list, new suppliers without articles are not showed.

Is there any trick I can use?

thank you,
Michele

 

[cheesegrits]

Not sure what you mean. Find me on Sype ('cheesegrits') and walk me through it.

-- hugh

 

[cheesegrits]

As per Skype session, you had selected an "INNER" join, which only selects rows where there is a match in both tables. You needed the default, "LEFT" join which selects all rows from the main ("left") table and any matched rows from the child ('right") table.

If you think of it as a Venn diagram with two circles, a LEFT join is the whole thing, an INNER join is just the intersection.

-- hugh

 

[miki]

Thank you very much for the clear explanation.
regards,

Michele

 

[troester]

You can close solved threads by unchecking "open" in Thread Tools.