Hi,

First of all I'd like to say what a great product you've put out. I'm really enjoying using wpDataTables and it is doing (almost) everything I need but I wonder if it's possible to use it to do this last thing.

I have set up a pair of Master-Detail forms where I've used the Relationship definition facility to pre-filter the data in the Detail table when I click a button that I've added to each row in the Master table. (The button I've created as a URL Link type and use the column filter URL parameter with the value of the Master record's ID so the pre-filtering works.)

But the thing I really want to be able to do now is access that same Master record ID so that when I create a new record from the Detail form it's connected to the correct Master record.

I hope that makes sense!

I'll try to illustrate with an example.

Let's say my Master table is Customers and the Detail table are Orders. Each record in the Orders table will have its own unique ID but it will also have a foreign key back into the Customers table to say who the Order belongs to.

So I can have a form for the Customers with a link on each row into the Orders table so that when a link is clicked on a particular Customer row the Orders come up for just that Customer. That's all working.

But from the Orders form which is showing the Orders for just that Customer I now want to add a new Order for that Customer. But I need the Customer ID value to put into the Orders table. How can I get that?

 I hope it's possible to do this somehow. I haven't seen an example of this in the documentation set.

Thanks,

Andy

So I have added 3 screenshots.

Customers.png is my "Master" table - holds details of my Customers. As you can see, on each row is a link to the Skates page with a pre-filter set to match the ID of the Customer.

The Skates.png screenshot shows the skates data for JUST THAT ONE Customer.

I then click New and the data entry form AddSkate.png appears. What I want to do is pre-populate the customerID field with the same value that was passed to the Skates page by the pre-filter so that if I add a skate it automatically adds it for the Customer whose records I am viewing.

Does that make more sense now?

Andy