Action - Copy data in row onto next row of same table

[Crimeboss446]

I want to create an action that will duplicate the information in a row onto the next row when saved. The duplicated row would change the order of the data so that the colums appear as the following order.

Manuel entry: Car, Driver 1, Driver 2

Action Copy entry: Car, Driver 2, Driver 1

So far I have been able to create an action that does the copy the data when saved, but the information keeps over writing the manuel entry row instead of the following row.

Any suggestions?

[Marc_Dillon]

Possibly a key issue. How have you defined your keys?

Showing a screenshot of the action that you setup would probably help too.

[Crimeboss446]

Here is the action

Here are the Dogs and Doglink tables as an example

The action is triggered when the Doglink form view is saved

[Marc_Dillon]

It looks like you're using the same key value for the new record. Doing that will effectively overwrite the 1st record. You need to assign a new key value.

[Crimeboss446]

If I use a new key, then I lose that link connection between the two dogs. My goal is to see the same doglink from both dog profiles. I figured if I made an action that kept the DOGLINKID key and inverted the DOGIDs it would work. Anywork around? 

[Marc_Dillon]

What is it that you're trying to do here? "see the same doglink from both dog profiles"... you should already have that with the single record with 2 dog refs in it.

[Crimeboss446]

I want to be able to select either dog, and then create a doglink which has information about their relationship.

As of right now, when I create a doglink, im selecting dog A and dog B to create the link. But when I go to view the link, I can only see it from dog A profile, but not dog B. 

Both dog A and dog B should have access to the doglink information that is stored in the Doglink table.

[Marc_Dillon]

What is preventing you from seeing the doglink from dogB? The [dog2] column is a Ref column, right? Then there should be a [Related doglink by dog2] column in the dog table.

[Crimeboss446]

Here are images of both table columns 

Here are the two inline views when observed from Dog A and Dog B

Here is the Doglink view that I can only view from Dog 1

 

[Marc_Dillon]

Right, so from Kyle's record, you'd see the same doglink in the inline view associated with the [related doglink by dog2] column. You aren't showing that inline view in your screenshots, do you not have it visible on your dog_detail view?

[Crimeboss446]

Good evening. Gaining some headway here. So one of the ref virtual colums was not checked. I can see the connection from both profiles now. However, how do I set it up so that I only see one inline view instead of both?

Here is the current profile appearance

 

 

 

[Marc_Dillon · Accepted solution]

Add them together. [Related....1]+[Related...2]

[Crimeboss446]

Thank you Marc. It worked just how I envisioned. Thanks for the patience as well. God speed.