Thread: Field that is a link (rs) and/or text field question

Hi All,

Ok, I have the following field on my form because if the Item does not have a price (intItem is ItemCost) is not zero then I don't want to allow users to change/update the ItemDescription but it will also be a link to BOMMaster page....but if it is zero they can have a text field to input a ItemDescription, these will not have BOMMasters....

Code:

<TD align=right>
<%
If intItem <> 0 then
%>
<a href="//testserver/application/BOMMaster.asp?ItemID=<%=rs("ItemID")%>" target="_blank"><%=rs("ItemDesc")%></a> &nbsp;</TD>
<%
else
%>
<INPUT CLASS="clrBg" type="text" name="InputItemDesc" size="30" maxlength="4" value="<%=rs("ItemDesc")%>"</TD> <%
End If
%>
</TD>

Question: I added "InputDescription" field to my tblDetails, how can I update this field from the above code? since I dont have a (Name="InputItemDesc") on the ones that do have a itemcost? Right now "Desc" (rs) is being pulled from another table (tblItem) "ItemDescription".

Hiya JMH,

But my form has multiple items, example:
The underlined ones below are the ones with a itemcost > 0

Code:

Category1
-Group1
ItemDescription1-Q1-Q2-Q3-Q4-DistrictCost-ItemCost
ItemDescription2-Q1-Q2-Q3-Q4-DistrictCost-ItemCost
ItemDescription3-Q1-Q2-Q3-Q4-DistrictCost-ItemCost

When I do my update, I will look at RegionID,DistrictID,ItemID.....will that still work like that?

Ok, kind of....I think I'm still a little confused by myself dealing with the ones they can change (desc/input cost)....let me give it a try and see how it comes out....Thanks JMH!!! Will keep ya posted on the progress.

oops...just saw your reply...was in shoutbox.

i have an Item table where the item desc and cost is stored...some of those items are $0. Those are items that I need to allow to change the Item description and the cost (because desc is something like Misc.). All other items should not be changed.

so since each district will have its own results, i added a details table which will hold each districts details (items/cost/qtrs, etc.) but I went back and added a location cost field and district input desc field because i need to show any ones they can change the desc/cost as what they change it to.

but now since the asp code looks to see if the cost is $0....what happens if they have entered a price for a misc item and put $20, they will longer be able to change it.

should my view contain both the cost from items table and district cost from details table..? would this take care of the issue above?

Hopefully i did it right.... I've attached the sql tables that I'm using. I created a view but it's not in the attached file, should i script it too? I've got the asp page setup to show all categories, groups, items then it sums each category, then a grand total at the end. just need to work on flow/edit screen (only edit items that are Misc items with $0). All others should stay as assigned in the items table because I will need to somehow show a page with all Regions/Districts combined.

I'm thinking i'm going to plug in data into the details table for each districts with Null in the qtrs so they can have something to start with....then all they will be doing is editing those same records.