2. ASPRunnerPro General questions
  3. session variable
This topic is locked

session variable

 		10/22/2013 3:13:23 PM
ASPRunnerPro General questions
J
 jmccullough author

I have two tables: Athletics and Bid Table. I list all items in the Athletics table
itemnumber gendesc units quantity price [Bid on this Item} Bid on this Item is a button which opens up the Add.page of my Bid Table so that a user may place a bid on an item.
Can I have the itemnumber of the Athletics table automatically be inserted into the ItemNumber field on my Add.page of my Bid Table when the user clicks on the button and opens the Add page. Can this be done using a session variable ?
Any help is appreciated.
mperry622 10/22/2013

Yes you would want to capture the previous number before you add and have it entered into a custom field.
Are you using any child/master linking? Your Bid table seems to be a good spot for a child table and link em together. use the item ID to link the two tables and it will auto link when adding a new bid record..
I will help where i can
J
 		jmccullough author 10/23/2013



Yes you would want to capture the previous number before you add and have it entered into a custom field.
Are you using any child/master linking? Your Bid table seems to be a good spot for a child table and link em together. use the item ID to link the two tables and it will auto link when adding a new bid record..
I will help where i can
J
 		jmccullough author 10/23/2013





Mike, thank you for the quick response. I linked the Althletic table to the Bid table using the Item ID # as you suggested however when I click on the "Bid on this Item" button to open the Add page the Item ID # is still not prepopulating. Do I need to capture the Item ID # as a variable anywhere else ?
Thanks for your help.
mperry622 10/23/2013



Mike, thank you for the quick response. I linked the Althletic table to the Bid table using the Item ID # as you suggested however when I click on the "Bid on this Item" button to open the Add page the Item ID # is still not prepopulating. Do I need to capture the Item ID # as a variable anywhere else ?
Thanks for your help.


No problem sir.. I know how frustrating this application can be. I would have thought because you have them linked with the itemID # when you are on a item and add a bid it should inherit the ID#.. unless the tables are linked but you are simply adding a new record.
any chance you have this project exposed? I would love to take a look at it.
mperry622 10/23/2013



No problem sir.. I know how frustrating this application can be. I would have thought because you have them linked with the itemID # when you are on a item and add a bid it should inherit the ID#.. unless the tables are linked but you are simply adding a new record.
any chance you have this project exposed? I would love to take a look at it.


http://demo.asprunner.net/mperry_keyinfotech_com/Project6/dbo_List_list.asp
I setup a demo mocked account of what your describing...
Once in click the bid hyperlink next to the item and then click add on next screen ... notice it auto brings in the ID#.. let me know ill show you what i did.. very easy sir.
J
 		jmccullough author 10/23/2013



http://demo.asprunner.net/mperry_keyinfotech_com/Project6/dbo_List_list.asp
I setup a demo mocked account of what your describing...
Once in click the bid hyperlink next to the item and then click add on next screen ... notice it auto brings in the ID#.. let me know ill show you what i did.. very easy sir.


Very nice and very close to what I am trying to achieve. When clicking on the "Bid" button I would like to open my Add page directly where my users can fill in the quantity field and click on the Save button. I would gladly post my project if you can tell me how. It would be much easier for you to see what I'm trying to do rather than me trying to explain.
Thank you
mperry622 10/24/2013



Very nice and very close to what I am trying to achieve. When clicking on the "Bid" button I would like to open my Add page directly where my users can fill in the quantity field and click on the Save button. I would gladly post my project if you can tell me how. It would be much easier for you to see what I'm trying to do rather than me trying to explain.
Thank you


Problem with that is the bid log is the child records to the main table. you have to drill into the list before you can add. let me play with the one i have setup or go ahead and post yours.. I will help ya through this.