plj63

Thanks that works. I have 2 futher questions.

If a person is found the search form displays a table with edit option. Is it possible to go straight into the edit mode after the search so that the person can update the information?

If a person is not found an empty table is shown. Again is it possible to go straight into edit mode. All fields are empty except for the first and second names. The person fills out the form an anew person is inserted into the DB

Thanks for your reply

Hi

Brilliant. That works very well

Many thanks

Hi Peter

Thanks for the reply. Here is a URL.

the page ‘team’ has the shortcut [wpdataaccess pub_id=”2″] of the data table ‘Match’

https://testwp.nyonrugby.com/team/?scorevisitor=$$37$$

The master data table is ‘Results’ and the shortcut is in https://testwp.nyonrugby.com/results-summary/

The above test should show the match of 10-dec-1972 but it shows the first entry

Ideally I wold need a lookup URL that has the aruments for the date,host and visitor columns.

Hello Peter

Thats exactly what I need thanks. My master data tables is called results and the detailed data table is called match. So there would be a link in teh results table to show the details of a match. I set the match table as explained in the doc.

However when I give an argument to the URL I get the detailed table for the very first entry match regardless of the what I give in the URL. So Im missing something

Do I need to add anything in the WHERE Clause? Note that for the moment Im using the free version

Thanks for your reply

Hi Kim

It appears that using httpGet[‘param_name’] is a premium feature only.

Is there another option available on the free version?

Thanks

Hi Kim

Thanks for your reply.

I would have a link on the page that lists the summary of people, for example using a more… link. So If I have a table of people details and a page showing a summary list as follows

| Date | First Name | Last Name | |

| 12-Jan-2024 | John | Doe | more… |

| 13-Jan-2024 | Mary | Smith | more… |

The more… link would show more details for a given person. This could open another page or a pop-up