How to do this form?
I'm changing a db from access to fm and need to know the best way to do a piece.
A db of bowling teams for a non-profit fundraiser. There's a teams table and form. The primary key is a combination of captain's last & first name, company name, and team number (the captain might head multiple teams). There's a schedule table and form that has a primary key of bowling alley name, lane number and date/time. To make it easy to link, when a team is made an auto-serial number is assigned. The schedule has a field for the same. It's a 1-to-1 relationship. I used the serial number for ease of design. It could literally link on captain name/company/datetime.
When viewing a given team you can click a button and bring up the schedule form. This is a list of slots (alley, lane, date/time). Several hundred of them. The whole list displays and the scroll bar lets you scan through it quickly. (One nice thing about access, as you move the scroll, the display moves so you don't have to let go to see how far you've scrolled, or you don't have to page down in chunks.)
If this team has already been scheduled the form jumps to that position, which is important. There are buttons to show all slots or just open slots, and buttons to sort by date/time or sort by location. (When you have someone on the phone and you're trying to say "how about this location at this time? No? How about that location at that time?" you want to scan and see what's available quickly.)
When you want to assign a team to a slot you pull down a list that shows captain name/company/team and chose yours. It doesn't have to be this particular method of assignment, just what was user friendly. It could be that you click a button and it fills in with whatever team you left open back on the teams form. That's a little less convenient because sometimes they're shuffling people and going up and down in the schedule moving this one to this slot and that one to that slot. To unschedule or change schedule you delete the name in the captain field, then find another slot and assign them again.
When you close the schedule and are back at the teams form the alley and date/time show on the team form.
This is mostly going to be accessed through Instant Web publishing.
Since both FM's list and even table is not as quick to work with, and web viewing limits to a list of 25 or a table of 50 and then you have to walk through page by page, I was thinking of this design for the schedule: A radio box to select showing this alley or that alley or both alleys. There are only 5 or 6 days for this event so a radio box to select showing only day 1,2,3,4,5 or all. If you select a day and alley you only have 36 lanes so (in list view) two pages to flip between, which is manageable. One catch to this is I don't see how to put several controls on a list view.
An alternative would be to make each line contain the alley name, date/time, and then 36 checkboxes all on the line indicating if lanes are scheduled or open (or maybe a count of open lanes?). That way you could look at a lot of slots at once and see if there are openings. If so then there would need to be a way to open another form with a detailed view of that slot that shows who is scheduled in each lane and add your team to an open one.
I'm betting some folks who do FM design a lot know exactly how they would do it and could save me a lot of going down the wrong path for what works well in FM.