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.