Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


VB6+Data Environment+SQL+ADO

GuestID is the PK of GUEST table and FK in BOOKING table (BookingID is PK of Booking table). On the Booking Form I want to display the Lname's in a Datalist of all those Guests who have made a Booking. How can I do this? The query is simply "select Lname from GUEST where GuestID = THISID (that is BOOKING.GuestID). I have made the sql command in the Data Env. How can I run this sql command and supply the parameter? What event do I put this code in - is it in Form_Load?

I'm really stuck..any help is much appreciated.


Sign In or Register to comment.