Frontpage Additional and delete from database issue

D

Dennis Burgess

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
 
D

Dennis Burgess

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top