Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How to do this form?

 
   Database Forums (Home) -> FileMaker RSS
Next:  Table variable populated from stored procedure [S..  
Author Message
njem

External


Since: Jan 25, 2010
Posts: 1



(Msg. 1) Posted: Mon Jan 25, 2010 10:37 am
Post subject: How to do this form?
Archived from groups: comp>databases>filemaker (more info?)

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: The schedule header has a radio box to choose showing this
alley or that alley or both. There are only 6 days of this event so
another radio box to pick a day. Now it's down to a managable list
(maybe 36). The form shows 1 line per time slot and how many lanes are
open in that time slot. (So this needs some summary or running total
with a break field.) A button on each line would open details of that
time slot showing each lane and which are open and what team is in
scheduled slots. Here, by one method or the other described above, you
can assign a team to a lane.

I've played around in FM and gotten a report/form to show something
like that. Two problems. One, when I click on the button on a line and
go to the details form it's not on the right record. Two, it doesn't
show the list in web view. I gather the limitation in web view is that
subsummary parts don't work? Is that right? Is that the only or key
limitation for such a form in web view? I read the web view doc but
it's not very specific. Just says something about "complex" forms
won't work but not exactly what won't work. I can get a summary count
for a given time to show in the footer but can't get it to show a
whole list of them.

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.

Thanks,
Tom

 >> Stay informed about: How to do this form? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
how do i create an expandable form? - Using FMP 8.0, on Windows Xp Pro. I'm designing a form that will list all the components needed to build an object. The number of components will vary, based on the object's requirements. I could use a portal to do the data entry of all the necessary..

How to set up Filemaker to avoid decreasing of speed - Please if somebody can help me! I have database of 1.6 mil subscribers (cca. 1.2 Gb, 60 fields, FileMaker Developer 7) - where I want to put average amounts (of 7 different revenue types) from 6 different databases (each database has monthly revenues). ...

File extension to force Tab-Delimited Text Import? - Has anyone found a way to force FileMaker 7 Server to use "Tab Delimited Text" as the import type in a scripted import? It seems that the file type is not remembered as part of the import step. I'm importing fixed-field data in to a text fie...

Fastest way to make related records? - I'm using FM server 7. I have a table that has 25,000 records in it, and I need to make related records in a join table. The two tables are related by a two-field match (ID and Date). I've come up with several ways to do it, but none of them work....

Identifying Connected Users in FMP7 - Hi All, I am using a small network of FMP7 users connected in a PTP network. I want to see the User Names connected to the database at any time. I can find no script or function to do this - the only way I can do this as the File Host, is to "attem...
   Database Forums (Home) -> FileMaker All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]