Solved Tip for linking lists

[elmarra]

Good morning everyone.
I want to ask for your advice and give me inspiration for an idea.
I have two lists.
1) Vehicle list
2) Vehicle Management.

The vehicle list is used to insert a new vehicle if necessary such as name type etc.
And it has various elements including insurance expiration date etc.

The Vehicle Management list
Instead, I have items including vehicle selection
Like if maintenance expires insurance etc.
And using the php plugin, when a new record is inserted, for example, the elements in the vehicle list are updated.
Being short of ideas, I wanted to ask you for advice on how to somehow make a connection to the two lists.
I didn't merge the two tables because I want to keep them separate.
But for example I want that somehow from the vehicle list I can recall the management list and insert the records there.
At the moment I don't know what the most constructive and intuitive solution is.
I was thinking:
- Custom form to place under the vehicle list
- A link or button always below the vehicle list.
Or do you have other ideas??
Because currently from the vehicle list to go to the vehicle management list I have to do it via the menu and I would like to create it in a more intuitive way.
I will accept your advice and ideas.
Thank you

 

[lori19]

Hi there

Maybe you should check out the repeated group feature. With this you could have all the different management information attached to each vehicle. (It looks like one database table, but technically they are separate, in case you need it for something else).
Here's how to do it:
- You open a new group in the vehicle table, call it management and make it repeatable
- You move all the fields from the management table into this new group
- Done. Now, your vehicle details view shows a section called Management, where you can add as many records as you want.

Note: If your management table contains already date you will need to move it using phpMyAdmin.

Kindly,
Lorenz

 

[troester]

An other means to 'connect' lists but keep them separated could be the RelatedData feature.
If you have a listA containing a dbjoin element to listB (not multiselect) you can activate RelatedData in ListB's settings. Have a look at the Wiki (I'm not at my PC At the moment)

 

[elmarra]

Thanks everyone for my advice.
I actually wanted to keep the two lists separate.
And I needed some advice!

An other means to 'connect' lists but keep them separated could be the RelatedData feature.
If you have a listA containing a dbjoin element to listB (not multiselect) you can activate RelatedData in ListB's settings. Have a look at the Wiki (I'm not at my PC At the moment)

I really missed it!
I used it a while ago!
And that's exactly what works for me!
I keep the lists separate!
But from the A list! with linked data I have the link to the details, and the ability to add new records directly from there!
Thank you