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.

Howdy, Stranger!

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


In this Discussion