Auto-enter calc. when related record is created

[DikkeHenk]

Hi

Problem:

When I (auto)create a related record (through a portal -'allow creation' in the PortalRelationship is on-) I want to auto-enter the _IDKeyField in the new related record with a multikey.

Field: _CategoryGlobal resides as Globalfield in the realted table

auto-enter multikeycalc: (_CategoryGlobal & "¶" & Get(RecIDnr)

When create the record by hand on the Lay-out of the related table (Current Table shown) everything works fine but when the record is auto-created through the portal the _IDKeyField has been set with _CategoryGlobal only. It seems Filemaker only auto-calculates in the active (current) Table.

Am I right and how can I solve the problem?

Thanks

[Dr. Evil]

I would leave the match fields alone and feed off of them.

Use a separate calculation field for your multi key.

You never want to tamper or complicate your matchfields/serial numbers/id's.

What do you need the multi key for? Usually it is used to filter records via relationship or value list built from a relationship. And I don't see why you would want to filter or sort by the serial numbers.

Looks like you are labeling records with some sort of category? I have attached a sample file that uses categories to filter record relationships. This may help explain what I am talking about.

I may have completely misunderstood your question, hope this helps.

MultiKey.fp7.zip