This topic is locked

Add new to linked table from Master Table

5/6/2008 11:21:02 AM
ASPRunnerPro General questions
B
Bryan author

Hi,
I have a master table called Company and a linked table called Employees.
On the Company LIST screen, I'm able to view the Employees table (using AJAX) but is there any way I can ADD an employee without opening the Employees table first?
Thanks,

Bryan
ps. Is there a forum / thread for a list of planned features for ASPRunner?

J
Jane 5/7/2008

Bryan,
just create link (on the Visual Editor tab --> HTML mode) to the add page of Employees table on the Company list page.

Here is a sample:

<A class=tablelinks href="DetailTable_add.asp?{$row.1DetailTable_masterkeys}" >DetailTable</A>


Then add following code to the Add page: Before process event:

if request.querystring("masterkey1")!="" then

Session(strTableName & "_masterkey1") = request.querystring("masterkey1")

Session(strTableName & "_mastertable") = "Company"

end if