Hello Darren.

Thank you for your interest in our plugin.

I am sorry, but I did not quite understand the question. Could you please explain in a bit more detail what you mean?

You can create a table which has two blank columns in PHPMyAdmin, so users can enter the purchase order and part number, if that's what you mean.

Best regards.

Ok, Darren.

So, the table already exists in your database, and you'd like to create a new one in wpDataTables which would pull the purchase history based on part number and purchase order number. Would you have a new table for each user, or one table for all users?

I believe it could be done, I'm just trying to figure out how you'd like to do it, and what the new table should display. You could use foreign keys, or pull the data using query based on a unique ID for a specific user.

For example, each user has his own ID - so you could create a new table generating a query from an existing table, where you'd pull the user ID, user name, purchase order number, part number and populate by date only for that user.

Is this what you're looking for? Could you send me an example in Excel, or something similar, so I can recreate it in our plugin and show it to you?

Best regards.