Update fields dynamically?

[nebon]

hallo there .. I have the following problem :
I have 3 tables

tblShow:
SHOW_ID
FILM_REF
SHOW_DATE
SHOW_TIME
SHOW_SEATS
SHOW NO
--------------------------------
tblBooking
BOOKING_NUMBER
MEMBER_REF
SHOW_ID
BOOKING_DATE
BOOKING_SPEC_NO
---------------------------------
tblFilm
FILM_REF
SEASON_ID
ORDER_NO
FILM_TITLE
FILM_CAT_TYPE
FILM_PRICE_PW
FILM_NO_WEEKS
FILM_DESC
FILM ITEM NR



okai now to the question , I am trying to create a booking where the user only needs to select the Film_title , then the query should automatically locate the appropriate shows and list them in a list with show_date and Show_Time , I have tried to do this in a query , but his wouldnt work , could someone help me by telling me how to do this ,please ? thanks alot in advance !

 

[jeremie_ingram]

Use a combo/drop down list box to display the selections of Film_title. In the AFTER UPDATE event of the combo/drop down list box place code to
1) Use the WHERE stament to populate the next listing in accordance to what was selected within the first combo/drop down list box.
2) Display and/or enable the seclond combo/drop down list box

So, the user selects the movie in the first combo/drop down list box. The second combo/drop down list box will appear/enable with only the contents that are releated to the selection in the first combo/drop down list box.

 

[dcx693]

Sounds like this will work fine with just a query if you have a one-to-many relationship between the tblFilm and tblShow tables on FILM_REF.

I would present a combo box with film names on a form and set up a query to display appropriate show times in another combo or list box from the tblShow table. The query rowsource of that listbox would be something like:
SELECT * FROM tblShow WHERE FILM_REF=Forms!YourFormName!cboFilmName

It's easiest to build that rowsource by looking at the listbox propertie sheet and clicking the button to the right of where it says "rowsource". That will bring you to the query design window and you can create it using a QBE grid.

 

[nebon]

first thnx alot for the help guys!
and... here is the problem :
"Use the WHERE stament to populate the next listing in accordance to what was selected within the first combo/drop down list box. "


how can I do that ??
I mean how can I update the query after the AFTER update

thnx again guys

 

[nebon]

Thanks alot for the help guys, I am almost getting it to work !