Adding links to Edit Form and Pass Value

Adding links to Edit Form and Pass Value

I have a relatively simple DB schema.  I am building an application for a charity auction.  There are multiple bidders, each of whom will likely bid on and win a number of different items.  We won't know the price they will pay for an item until the auction is over.  At end of the auction, we need to list all of the items that each bidder won and total up how much they owe.

There are 3 tables:
(1) Bidders.  While there is information here like name and contact info, we are concerned with 3 fields:  BidderID (unique), Total Owed (the total they owe on all items as confirmed by them and the staff) and form of payment (cash, check or credit card).
(2) Auction Items.  The only relevant fields are ItemID (unique) and ItemDescription.
(3) Winning Bids.  This basically joins together the two tables above.  Once all the bids have been made, for every item we will enter the AuctionID, BidderID and WinningBidAmount.  (There may be multiples of each item.)

At the end of the evening, each bidder will come to checkout to determine how much they owe, pay us and collect the items they have won. Using a Winning Bid View, the checkout person can view all of the winning bids.  They will obtain the BidderID from the bidder and filter the Winning Bid View to see just those bidder's items.  The following information will be displayed:
  • For every item won, the ItemID, the winning BidderID and the WinningBidAmount
  • The total of all of that bidder's Winning Bids
  • Buttons to Edit the Winning Bid, in case there was a mistake
  • A checkbox and button to delete a Winning Bid
Question 1:  Once the bidder has confirmed all of the items, the check out person needs to go into the Bidder form for that bidder (in edit mode), input the total of all winning bids, and indicate the form of payment.  I have not figure out a way to provide a link to the edit form for that bidder.  (The only edit forms are for the Winning Bids.)  How can I do that? If I click on the BidderID it shows a View of the bidder form, but that can't be edited.  I was hoping to automate this.

Question 2:  Also, I would like to automatically grab the sum of the Winning Bud amounts shown on the view and insert it into the Bidder edit form.  If I could attach the total amount as a parameter to the edit form, that seems like it might be possible.

On a less important note:
  • The winning bid is a currency field.  How do I display each winning bid and the sum with a $?
  • How do I add the word "Total" before the sum
Any help would be greatly appreciated.