Best practices for joining tables in form

(0) Share

Report

Posted on by Eisenberk

Hello,

I have three tables: TableA, TableB and TableC.

The current relation is:

TableA <---> TableB <---> TableC

I am currently working on a form to do some filtering. This form is based on records from TableA and TableC. Table A and Table C has a common field, so it's easy to make a relation.

The thing is, both tables have a relation with Table B and this TableB is a big one, so i don't wanna load it on the form, mainly because i don't think it is necessary.

¿Would be a good practice to make an AOT relation between TableA and TableC to use them both as a datasources on the new form? Or it is redundant.

Another way is to create the relation on the init method in the FormDataSource (addDataSource, addLink, etc..)

What do you think? I am in a constant search between redundancy, performance and standardization.

Thanks.

All responses (1)

Answers (0)

francesco.sch 55 on at

Like (0)

Report

RE: Best practices for joining tables in form

Could be an option for you to create a view in which you have table A and C and then use dynalink in form with table B? I don't know how much standard it is but could be a good solution in performance terms.