FrontPage Programming - Frontpage Additional and delete from database issue

Author

Frontpage Additional and delete from database issue

Dennis Burgess

2004-09-29, 7:18 pm

ok Heres the scoop

cust table

id
firstname
lastname
datetime

part table

id
custid
partno
datetime

What I have is a form that shoots the id from the cust table to a another
asp page just by having the ?formid=xxx at the end of the url.

It pulls the correct info in both the database results for the customer name
and the parts that have a custid that matches the formid in the URL.

Now I want to ADD a part from the same asp page, so I dropped in a form, and
put a textbox for part number, and shot it to the part table. Id is
autonumber, then in the advanced properties, I put in that the custid would
= ::formid:: or [formid] whatever. It just drops in the formid, not the
acutal number above in the URL.

How do I do this with my form?

Second, once I click submit on this form to add this part, I want it to
repull the same ASP page, with the same formid that the orginal customer
listing page does. But I have not figured out how to carry the formid from
the URL over to another page or to reload it again.

Dennis

Dennis Burgess

2004-09-29, 7:18 pm

Ok.. I got it with a extra field that I had to have.

How do I get it to return to the same formid after the form submit?

Dennis

"Dennis Burgess" <dmburgess@surdyke.remvove.com> wrote in message
news:uC2uI2lpEHA.2864@TK2MSFTNGP12.phx.gbl...
> ok Heres the scoop
>
> cust table
>
> id
> firstname
> lastname
> datetime
>
> part table
>
> id
> custid
> partno
> datetime
>
> What I have is a form that shoots the id from the cust table to a another
> asp page just by having the ?formid=xxx at the end of the url.
>
> It pulls the correct info in both the database results for the customer
> name and the parts that have a custid that matches the formid in the URL.
>
> Now I want to ADD a part from the same asp page, so I dropped in a form,
> and put a textbox for part number, and shot it to the part table. Id is
> autonumber, then in the advanced properties, I put in that the custid
> would = ::formid:: or [formid] whatever. It just drops in the formid, not
> the acutal number above in the URL.
>
> How do I do this with my form?
>
> Second, once I click submit on this form to add this part, I want it to
> repull the same ASP page, with the same formid that the orginal customer
> listing page does. But I have not figured out how to carry the formid
> from the URL over to another page or to reload it again.
>
> Dennis
>
>