Hi
this will be hard to explain:
I have:
A table that contains new customer info that was entered from a Web-form. Table1
A master database that may or may not contain this customer. Table2
The entries may or may not be matching perfectly due to typos or address or phone number changes.
I want to avoid to transfer new customers into the master database that actually are already in there in some form.
I would assume that this is a common problem...
I envision to have a Page that shows one record of Table 1 as TabularGrid1 on the left and a grid of Table2 on the right. (Grid 2)
I want Grid 2 to show matching or closely matching entries of table one.
There is no problem to get the two components on one page with the "page layout builder", but I have a hard time to pass data
from the display of TabularGrid1 to the search/filter for grid 2.
I envision that the user could click on a button "Phone" which transfers the phone number to the Grid2 Search field.
If there is no phone# match, the user can to the same with First Name and/or last name or combinations..).
Show me all "Joes" in New Orleans
Show me all customers living in "Short St" in "CA"
This should narrow the choices quite a bit.
I know I can fill a search field with {grid.Object}.setvalue(S,....... but when I am clicking on something in the TabularGrid, this will be the
"Grid.Object".
I just occurs to me that if I find the "real name" of Grid2 with "objectexplorer" I possibly can do a realname.setvalue...
I will try that.
Any other or better pointers are welcome.
this will be hard to explain:
I have:
A table that contains new customer info that was entered from a Web-form. Table1
A master database that may or may not contain this customer. Table2
The entries may or may not be matching perfectly due to typos or address or phone number changes.
I want to avoid to transfer new customers into the master database that actually are already in there in some form.
I would assume that this is a common problem...
I envision to have a Page that shows one record of Table 1 as TabularGrid1 on the left and a grid of Table2 on the right. (Grid 2)
I want Grid 2 to show matching or closely matching entries of table one.
There is no problem to get the two components on one page with the "page layout builder", but I have a hard time to pass data
from the display of TabularGrid1 to the search/filter for grid 2.
I envision that the user could click on a button "Phone" which transfers the phone number to the Grid2 Search field.
If there is no phone# match, the user can to the same with First Name and/or last name or combinations..).
Show me all "Joes" in New Orleans
Show me all customers living in "Short St" in "CA"
This should narrow the choices quite a bit.
I know I can fill a search field with {grid.Object}.setvalue(S,....... but when I am clicking on something in the TabularGrid, this will be the
"Grid.Object".
I just occurs to me that if I find the "real name" of Grid2 with "objectexplorer" I possibly can do a realname.setvalue...
I will try that.
Any other or better pointers are welcome.