J
John Breen
Trying to set up a small fantasy football league online.
In the Picks table, I have a field called Game1 which is a
lookup field getting its data from a query. A sample
return of the query might let the user choose between New
England and Chicago with a third choice - Not Picked -
being a default item. So three available choices for the
Game1 field. Have tried this and it works fine.
I can get FrontPage/Access to display the existing pick
for Player 1 by querying the Picks table. But this only
shows the existing pick and does not allow the user to
change their pick to anything but that.
Essentially - How can I show the three available picks
while also having it default to the user's original pick?
And then, will I be able to update the database via FP (I
have only created append queries in the past - this would
be an update query). I assume this would require cutting
and pasting the SQL code?
Thanks much in advance.
John
In the Picks table, I have a field called Game1 which is a
lookup field getting its data from a query. A sample
return of the query might let the user choose between New
England and Chicago with a third choice - Not Picked -
being a default item. So three available choices for the
Game1 field. Have tried this and it works fine.
I can get FrontPage/Access to display the existing pick
for Player 1 by querying the Picks table. But this only
shows the existing pick and does not allow the user to
change their pick to anything but that.
Essentially - How can I show the three available picks
while also having it default to the user's original pick?
And then, will I be able to update the database via FP (I
have only created append queries in the past - this would
be an update query). I assume this would require cutting
and pasting the SQL code?
Thanks much in advance.
John