two data tables

alkil

Hi

I have two data tables which need linking

Only one column (text) is common to both tables, however is not an exact match. There is just one or two words that make a link.

I need an easier method where I can link the two tables on a monthly basis

Table 1 has product specific data from suppliers, with cost of each product
Table 2 has product specific data from customers, with sale price of each product and QTY sold

Any help will be greatly appreciated

Ta

kthorngren

Are you asking a question about the Datatables Javascript application?

If not then please use Stackoverflow or another forum specific to the product you are using. Or, provide more Datatables related information so we can help you.

Kevin

alkil

This is a general question, I am not using a specific application,

If someone has experience of dealing with sorting this kind of data, and would recommend a solution I would be happy to consider

Table 1 (Supplier): Description, Quantity, Unit Price Paid
Table 2 (Sales): Description, Sale price

kthorngren

Generally speaking you would tie the two tables together using a unique ID in one table and a field containing the appropriate ID in the other table.

Since this question is not specific to DataTables you will get a better answer by using a forum specific to the product that holds your tables. Something like Stackoverflow.

Kevin