Creating a specialization relationship

ak2h

New Member
I'm trying to create a specialization relationship from an ERD, however, there seem to be some problems with this.
Example: Relation "Automobile" with Specializations "Car" and "Truck" (really, just a simple example... :))
General fields will be stored in the general table "Automobile", like "Name", "HP", ...
Specific fields will be stored in the corresponding subtables, e.g. "seats" for cars and "load_capacity" for trucks. So far so good, just some 1:1-relationships.
Now to the tricky part: In the form itself, I want to show the general fields and a drop-down selecting the specialisation (car or truck), this should then trigger the display of the corresponding subtables fields for editing.
What is the suggested way to achieve that in Fabrik?
Thanks in advance!
 
You can show/hide elements depending on others with element's Javascript ( so e.g add JS to Specializations 'hide seats if this == Truck')

gesendet mit Tapatalk
 
You can show/hide elements depending on others with element's Javascript ( so e.g add JS to Specializations 'hide seats if this == Truck')

gesendet mit Tapatalk
Thanks for your answer. I can certainly do a lot with JS. However, since this is a rather basic concept in relational databases, I'm looking for a rather basic implementation concept for this.
 
We are in need of some funding.
More details.

Thank you.

Members online

Back
Top