Creating a form off of multiple tables

[John Meyer]

I have a table that has several foreign keys. How do I set up an update
form so that those foreign keys become drop-down lists. In other words,
I want the drop down list to populate the possible values from one
table, but the selected value comes from another.

 

[John Meyer]

I have a table that has several foreign keys. How do I set up an update
form so that those foreign keys become drop-down lists. In other words,
I want the drop down list to populate the possible values from one
table, but the selected value comes from another.

Okay, figured this one out using form view and a couple of datasets.
Can anybody point me towards a reasonably good tutorial on this subject?

 

[Jon Paal]

http://msconline.maconstate.edu/tutorials/ASPNET20/default.htm

look at <ASP:formview tutorial and dataset tutorials.