Re: [ppa-dev] Browsing on foreign keys

[Alexey B. <ale...@gm...>]

Hey Jehan,

> However, what you are reporting here is actually a bug for me.
> supporting multi-FK-per field or not, when clicking on a FK link, we
> shouldn't have a bad query, Leonardo, cold you have a look and fix it
> please ?

I'm not sure it is so easy to fix, I even don't know how to handle
such situations.

IMHO the best solution is to show 2 links for table_fk.id2 - one for
table_1(t1_id1, t1_id2), another for table_2(t2_id1, t2_id2). But it's
a complicated way. I'd choose it if I have enough time.

Some less complicated ways:
- Remove multi-FK at all. I'd choose it if I have not enough time.
- Choose the only FK from a list and correct link, but it is unclear
which FK to choose.

So I think before fixing you should discuss the problem with Leonardo.

BTW, how often do you meet multi-FKs in your practise? Is it really
necessary to implement them in PPA?