Question

detail tab with view shows display message

  • 12 April 2024
  • 2 replies
  • 26 views
Tejo van de Bor
Rank
Userlevel 2
Badge +5

hi,

We use a view in a detail tab where we combine two tables, a record can be added in the row. We use an instead of trigger to insert the records in het underlying tables. After adding the record, the message “saved data can not be displayed on this screen”, but surprise, the new record is shown!

 

 

Because of the two tables, two primary keys are added in this view, can this be the problem? Should I create a dummy primary key for this view?

Anybody an idea how to fix this?

2 replies

Mark Jongeling
Rank
Userlevel 7
Badge +23

Hi Tejo,

I believe the primary key can indeed result and prevent this behavior. Try and have a primary key from the List to Shipment package measurements that enforces a strong relationship. E.g. Shipment_id ↔ Shipment_id

On holiday May 6 - May 31
Tejo van de Bor
Rank
Userlevel 2
Badge +5

hi @Mark Jongeling, problem also in ticket 9207S cause I have other problems with the shipment_id column. I’ll add fix here when available.

Reply


Terms & ConditionsCookie settings