Use portal to create record in the table in the end of the relationship
I'm having a problem with creating records from relationships that are as follows:
I have a database that has three related tables, being what I call unit_of_knowledge (uok), rules and body_of_rules (bor). The relationships are:
Rules::BorID_fk=Bor:BorID_pk, with just one match field
Uok::kind=Rules::kind && Uok::RulesID_fk=Rules::RulesID_pk, with two match fields.
my problem is, I'm able to make a layout of BOR, make a portal of UOK and create related records in UOK. But that is because Rules is in the middle. What I would love to do is to make a layout of BOR, make in it a portal of Rules and, automatically, it would create also a new related record in UOK (for each created record of Rules). Is it possible? (always is; is it too hard?)