This topic is locked

Drop Down Selection.

2/24/2010 5:29:22 PM
ASPRunnerPro General questions
R
Roger author

Using Lookup Table selection in the Add Page and the record does not get added to the table. Here is the basic Table setup:
Accounts[Acct_NO]: PK related to Purchases via [Acct_NO].

Purchases: PK: Purchase_ID, IDX: Acct_no
In the GUI, I select Table (Accounts), Link Field (Acct_NO), Display Field (Acc_Name). The Test-it works and displays fine, but the data does not get added to the table.
There are no errors returned from ASPrunner 6, nor ASP nor MS SQL.
This technique does work because I've used it in another project and checked that project for the steps I used there.
It seems that I am doing everything right - but clearly I am really not. Just a putz today is all...
Any ideas?
Thanks.

T
Tim 2/25/2010

When you click Save on the add page to you get the "<<Record Added>>" message at the top of the page?

R
Roger author 2/25/2010



When you click Save on the add page to you get the "<<Record Added>>" message at the top of the page?


Yes, actually I should have mentioned that. But when I run my query tool on the table no new record was added. I'm going to revisit this DB, cause my next post outlines another issue.
I know for sure, nothing has changed, this has only begun in the last few days and we've looked and looked and looked. There's gotta be something really "stupidly simple" that I'm missing.
Thanks.