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. Should I use custom post types or a custom database tables for plugin development?
  4. Delete all posts of a custom post type—efficiently
  5. Order by & include array by specific post ids
  6. Get list of all registered post types slugs
  7. Custom Post Types, or completely custom?
  8. Custom Post Type with Input fields to seperate table on database.
  9. Right way of storing large number of custom post fields
  10. How to use custom database tables for custom post types?
  11. Limit the post for differents custom post type in the same wp_query
  12. array_pop() expects array, boolean given for $event_type_term ->slug
  13. Custom Post Type or Custom Tables
  14. Are custom post types suitable for storing high numbers of data elements, in this case chat messages?
  15. Custom post type or just use custom fields
  16. Create Pages from Database
  17. Use Custom Database with Custom Post Type
  18. Custom Search | Wrong output & question
  19. How do I write this SQL statement for Posts written in last 24 hours?
  20. Save or update data when custom post published
  21. update a post meta from a single table cell TablePress
  22. update custom post type meta from a shortcode
  23. Custom post type Vs. data in own table
  24. Using posts and postmeta table to store custom Address Book Plugin data
  25. Automatically adding meta data to posts or multiple query help
  26. How to use custom post type APIs, but use a different db table
  27. Developing WordPress on Kubernetes
  28. Recommended custom post type structure for TV Schedule site?
  29. WordPress post count not showing for custom post type author
  30. Where to store custom tagging data associated with a custom post type
  31. Create a post in custom post type using field in registration form after users submit form
  32. wpdb custom post_type problem
  33. Adding custom tables to WordPress
  34. My theme saves their custom post type’s metadata as a serialized array, how to access the keys?
  35. Save an array from drop-down in custom meta box
  36. WP All Import – Using Xpath to set a select value
  37. Sorting custom post type columns with external data and without meta values
  38. How to use custom taxonomies to reference complex relationships?
  39. Create a clone from one WordPress site to another in a few minutes
  40. How to store multiple values in 1 meta_key with radio input?
  41. Display a CPT based on a metabox selection
  42. Database to page routing API?
  43. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  44. How to handle a CSV with 65,000+ rows and make it searchable?
  45. How to change wp prefix for custom post type only?
  46. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  47. Modification of how the data is controlled/showed and stored
  48. Add update or delete database records using custom post type
  49. How to import a custom MySQL DB table into a WordPress custom post type
  50. Display post content with respect to its title?
  51. Storing a many to many post type relationship in post meta and keeping SQL ability for Joins
  52. WP_Query orderby and tax_query
  53. Limit the post for differents custom post type in the same wp_query
  54. Importing Data from a Non-WordPress database, into WP
  55. How to organise this data within WordPress
  56. Organize WordPress site, so it can maintain with huge database
  57. Save custom post type to external database
  58. Show data from one Custom Post Type in another Custom Post Type
  59. Custom Post Types — $args vs. labels array
  60. Get an array wich contains the post_name of every post that has the custom post_type “pelicula”
  61. Specifying meta field’s column type in Database using add_post_meta
  62. Add first letter of titles to array, then compare arrays
  63. Is it a good idea to add a column to the posts table?
  64. Replace dynamically content in a custom database table when a custom post is created
  65. Query Custom Post Types with checkboxes
  66. Running a song lyrics site on WordPress
  67. Save and user submitted data from a form and display them in the wp backend
  68. Dump custom post type database
  69. Create Array from custom post type to display a slider
  70. Should I use custom taxonomies or not?
  71. Designing a custom post type with a minimum number of meta fields
  72. Inefficient Query Confusion
  73. Querying multiple values from a single key
  74. Allow front end users to add data to a custom post type
  75. Check if user has comment on current post
  76. WordPress hook which triggers on post import
  77. Update all published posts at once
  78. get_terms() returns Trying to get property of non-object error for custom taxonomy
  79. Custom Columns for Custom Post Type Manager
  80. Entity to store contact form entries?
  81. How do I disply an array inside a custom post type?
  82. Custom Post Type Field Array parsing [closed]
  83. Getting custom post types to properly display alphabetically
  84. Ideas to connect external database table to wordpress posts as custom field source
  85. Database alteration: users who voted
  86. WordPress as a frontend website for iOS app [closed]
  87. Using custom post types WordPress network
  88. delete duplicate meta_value with same post_id
  89. custom post type: own database table structure and custom “new-post” interface
  90. Import External XML
  91. Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
  92. How do you make relational post types in WordPress? [duplicate]
  93. How can I loop at a Specific Taxonomy from a custom post type?
  94. Update value inside array update_post_meta
  95. 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?
  96. Custom archive page for custom taxonomy and pagination issue
  97. Clone wp-admin/users.php (Users Admin Page)
  98. Get an array of the number of post per year of a custom post type (WordPress)
  99. Does this archive template part look like its making too many calls to the db?
  100. Query when is one or several values
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)