Save custom post type in different table

While I am a big fan of tweaking wordpress as much as it could because it allows us to, I think the best way forward is to have the best algorithm before coding.

Reading your question, I came across ” Actually, I have created two custom post type named 'truck' and 'drivers' “.

Issue: Linking two post types requires extra work as you are doing because natively it is not what WordPress does.

Suggested Solution: Do it, the way WP works naturally: Link a Custom Post Type to a taxonomy. So, instead of having ‘truck’ and ‘drivers’ as CPTs, have ‘drivers’ as CPT and ‘trucks’ as taxonomy! That saves you tons of work, and especially the risk of running into issues should WP Update.

You can then create the custom functionality of dragging and dropping on CPT and taxonomy

Related Posts:

  1. Where are wordpress custom types stored?
  2. Right way to store a large set of similar information on website? [duplicate]
  3. Delete all posts of a custom post type—efficiently
  4. Order by & include array by specific post ids
  5. Get list of all registered post types slugs
  6. Custom Post Types, or completely custom?
  7. Custom Post Type with Input fields to seperate table on database.
  8. How to use custom database tables for custom post types?
  9. Custom post type or just use custom fields
  10. How do I write this SQL statement for Posts written in last 24 hours?
  11. update a post meta from a single table cell TablePress
  12. update custom post type meta from a shortcode
  13. Custom post type Vs. data in own table
  14. Using posts and postmeta table to store custom Address Book Plugin data
  15. How to use custom post type APIs, but use a different db table
  16. Developing WordPress on Kubernetes
  17. WordPress post count not showing for custom post type author
  18. Create a post in custom post type using field in registration form after users submit form
  19. Adding custom tables to WordPress
  20. My theme saves their custom post type’s metadata as a serialized array, how to access the keys?
  21. Sorting custom post type columns with external data and without meta values
  22. How to use custom taxonomies to reference complex relationships?
  23. How to store multiple values in 1 meta_key with radio input?
  24. Display a CPT based on a metabox selection
  25. Database to page routing API?
  26. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  27. How to handle a CSV with 65,000+ rows and make it searchable?
  28. How to change wp prefix for custom post type only?
  29. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  30. Add update or delete database records using custom post type
  31. How to import a custom MySQL DB table into a WordPress custom post type
  32. Storing a many to many post type relationship in post meta and keeping SQL ability for Joins
  33. Limit the post for differents custom post type in the same wp_query
  34. Importing Data from a Non-WordPress database, into WP
  35. How to organise this data within WordPress
  36. Show data from one Custom Post Type in another Custom Post Type
  37. Custom Post Types — $args vs. labels array
  38. Get an array wich contains the post_name of every post that has the custom post_type “pelicula”
  39. Specifying meta field’s column type in Database using add_post_meta
  40. Add first letter of titles to array, then compare arrays
  41. Is it a good idea to add a column to the posts table?
  42. Replace dynamically content in a custom database table when a custom post is created
  43. Query Custom Post Types with checkboxes
  44. Save and user submitted data from a form and display them in the wp backend
  45. Dump custom post type database
  46. Inefficient Query Confusion
  47. Querying multiple values from a single key
  48. Check if user has comment on current post
  49. Update all published posts at once
  50. get_terms() returns Trying to get property of non-object error for custom taxonomy
  51. How do I disply an array inside a custom post type?
  52. Getting custom post types to properly display alphabetically
  53. Ideas to connect external database table to wordpress posts as custom field source
  54. WordPress as a frontend website for iOS app [closed]
  55. Using custom post types WordPress network
  56. custom post type: own database table structure and custom “new-post” interface
  57. Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
  58. How can I loop at a Specific Taxonomy from a custom post type?
  59. Update value inside array update_post_meta
  60. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  61. Custom archive page for custom taxonomy and pagination issue
  62. Clone wp-admin/users.php (Users Admin Page)
  63. Get an array of the number of post per year of a custom post type (WordPress)
  64. when looping through custom post data not appearing
  65. custom post types, custom fields and normalization
  66. Create 3 Levels of relations with WordPress
  67. Exporting Post type from one theme and importing it to another theme
  68. Staggering featured post using ‘sticky’
  69. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  70. custom data model – link and populate from admin backend
  71. Confused about where to store my data
  72. Changing an item in drop down after 5 latest posts per taxonomy
  73. Populate custom post type/custom fields from an external database
  74. Automatically convert standard posts with custom fields to custom post types
  75. In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
  76. CPT or Custom Table for Repository of Serial Numbers
  77. Trying to get custom post type attachment images to function in indexed array
  78. How to use TOC with ACF?
  79. How to enable the user to add value through the admin panel?
  80. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  81. Shared Custom post type between WP network sites
  82. WordPress custom field images not getting inserted into array
  83. Meta-Box to add multiple items one at a time and on publish save all
  84. Pulling Content from Existing Database
  85. Displaying database table in backend of wordpress
  86. custom post type for custom talbe
  87. Custom Post Type Author Array Problem
  88. taxonomy terms array not working
  89. Display custom posts in checkbox list
  90. Check in function on custom page
  91. posting twice from an array?
  92. Inserting into WP DB
  93. What is the most efficient way to manage changes my product comparison tables?
  94. WordPress and Unity high scores table
  95. Checking for published posts in a certain post type
  96. custom post types containing a collection of items
  97. WordPress Admin Page Slow. Customer Post Type is the slowest
  98. Display custom post type attached media file sizes
  99. What would be the optimal CPT / Taxonomy design for the following entities structure
  100. post__in select all custom posts and not the selected array of ids