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.