G
goldcomm
I need to provide a sign up form that allows the user to
select from a list of dates and times (one field:
date_time) from a drop down list. They also enter their
name in a separate
field. This is done on a form that is submitted to an
Access database.
The challenge: Eliminating the data and time from the drop
down list after a user has selected it, so that the next
person accessing the form cannot select the same date and
time.
I thought about a form with a hidden
boolean field that goes into a database column
named "booked" when the name and date_time is submitted -
then doing the dropdown menu as a database results with
the booked column as the criteria for displaying the
date_time- but that would be trying to make the output
(results) the input to the form and I don't know if that
is possible. Is there a way to use FP Database Results
displayed as a drop down menu as an input for a form
submission?
In other words I want to load a form,
that populates a drop down
from a database, and the dropdown is updated either each
time it
is loaded or after each submission.) I would hope to do it
using the FP database component.
Another idea I had was from page 891-892 of the book
MSFront Page Inside Out where drop down lists are
discussed. The author gives some code that allows you to
have options selected for Recycling Form Element Values as
follows:
I'm assuming "ddbox1" references option one in my drop
down list and the "1" is a conditional that checks the
status of the option, meaning if it is "1" it is selected
so proceed with the rest of the code. Is this correct?
Would option two be "ddbox2" ? Could I use that and
replace Write "selected" with some command that hides or
removes the option? Does anyone know of a command to do
that?
I appreciate any and everybody's suggestions!
select from a list of dates and times (one field:
date_time) from a drop down list. They also enter their
name in a separate
field. This is done on a form that is submitted to an
Access database.
The challenge: Eliminating the data and time from the drop
down list after a user has selected it, so that the next
person accessing the form cannot select the same date and
time.
I thought about a form with a hidden
boolean field that goes into a database column
named "booked" when the name and date_time is submitted -
then doing the dropdown menu as a database results with
the booked column as the criteria for displaying the
date_time- but that would be trying to make the output
(results) the input to the form and I don't know if that
is possible. Is there a way to use FP Database Results
displayed as a drop down menu as an input for a form
submission?
In other words I want to load a form,
that populates a drop down
from a database, and the dropdown is updated either each
time it
is loaded or after each submission.) I would hope to do it
using the FP database component.
Another idea I had was from page 891-892 of the book
MSFront Page Inside Out where drop down lists are
discussed. The author gives some code that allows you to
have options selected for Recycling Form Element Values as
follows:
I'm assuming "ddbox1" references option one in my drop
down list and the "1" is a conditional that checks the
status of the option, meaning if it is "1" it is selected
so proceed with the rest of the code. Is this correct?
Would option two be "ddbox2" ? Could I use that and
replace Write "selected" with some command that hides or
removes the option? Does anyone know of a command to do
that?
I appreciate any and everybody's suggestions!