difficulty with joining lists

[germanoalves]

Hey!
I'm having great difficulty joining information from 2 tables.

I've already read the documentation www.fabrikar.com/forums/index.php?wiki/list-joins/#one-to-many and I didn't get the result I need

I have a LIST A with text fields, dropdown etc.

And I have another LIST B, with a field to choose the date and time.

I need that in TABLE A I have the option to choose the registered dates in TABLE B, in a repeater group.

I've tested it in all ways but I couldn't perform this action, as simple as it seems to be.

How could I do this natively in Fabrik?


Thanks!

 

[troester]

This sounds like a many-to-many relation.

And I have another LIST B, with a field to choose the date and time.

Not sure what you mean here:
In this listB you have a dbjoin element (pointing to a listC) with different registered dates or a dropdown element containing the different registered dates or ...?
Or does listB contain the records with the registered dates?

 

[germanoalves]

Caso eu não tenha uma TABELA C, preciso que os registros que estão na TABELA B apareçam na TABELA A.

 

[lousyfool]

Thanks for continuing in English.
Google says:

If I don't have a TABLE C, I need the records that are in TABLE B to appear in TABLE A.

Sounds like you want a database join element in list A, set to look up the data in list B.

Note that list B should contain a primary key, which you can select as "Value" in the Data tab of the dbjoin element.

 

[germanoalves]

Thanks @lousyfool !

I thought I could accomplish this task without using the database join element.