hoyt202

Barbara, Thank you for responding and for providing the sample file. As I am not a developer by trade, I want to take the time to learn this correctly and reverse-engineer what you have shown. I like the direction you have gone in and I will work with it in list view to see how it looks with ~150 names. My hope is to have a new clean portal record show each time a new date or time is initiated.(This is the purpose, I think, for the date table). I see how your solution drops down to the next portal row, I was just hoping to eliminate, especially in list view with ~150 names, the need to scroll. Each new record will be date driven. Thank you and I will be providing feedback soon. (Holidays are demanding with 2 kids and one on the way!) Jason

I have viewed many tutorials and asked many developers to help me get to what I have already. What I have not asked is the following question: How do I populate my portal? Ok, here's what I have. An Attendance Solution that has three tables: NAME: _kp_name_id name enable DATE: _kp_date_id _kf_name_id _kf_status_id date STATUS: _kp_status_id status They are joined by the obvious keys. Lets say that the NAME table has four records: Bill Enable Mary Enable Steve Laura Enable What I am trying to do is get all of the names that are enabled in the NAME table to appear EVERY time in a portal under the DATE table. (Is this my first issue? Which layout view and table should my main and portal be based upon?) AND I also want the field status, from the STATUS table, to appear next to their names (as a radio-buttoned value list). AND I want this to be the case EVERY time I create a new Date record. So for example, I want the following: Record 1: DATE: 12/24/2012 Bill Present Sick Work Travelling School Other Mary Present Sick Work Travelling School Other Laura Present Sick Work Travelling School Other Record 2: DATE: 12/25/2012 Bill Present Sick Work Travelling School Other Mary Present Sick Work Travelling School Other Laura Present Sick Work Travelling School Other Record 3: DATE: 12/26/2012 Bill Present Sick Work Travelling School Other Mary Present Sick Work Travelling School Other Laura Present Sick Work Travelling School Other I want this to appear EVERY time. So, I ask, is this a filtered portal issue? A scripting issue? Will someone please be kind enough to help me through this?

doughemi, I have been able to sit down and try this and I am stumped on this one. I have attached a snapshot of my ERD and I will also attempt to explain the method to the madness. I will list any key fields and important fields: FAMILY NAME _kp_family_id name_last  MEMBER NAME _kp_member_id _kf_family_id name_first  These two tables were created first so that the last name of Jones (and other general family info like 123 Main St.) lives in the FAMILY NAME table and then the first name of Tom (and any other family member and specific info about Tom like cell phone, email, etc.) I can then have a directory page (with a Portal) like this: Jones -         Tom -         Mary -         Any kids, etc. I now would like to take attendance from an iPad using FileMaker Go and I have setup and also been helped by a few on here with the following additional tables:  SERVICE _kp_service_id _kf_member_id _kf_attendance_id date_service time_service  ATTENDANCE _kp_attendance_id status (value list driven (i.e. Present, Sick, Travelling, Working, School, Other, etc.)  I have joined the tables together, keeping the original two tables intact, like this:  MEMBER NAME                              SERVICE                              ATTENDANCE _kp_member_id                             _kf_member_id                                                          _kf_attendance_id         _kp_attendance_id  My design is to have a main layout from the SERVICE table (with date and time fields) with a portal from the MEMBER table (with MEMBER:_c_name_full and ATTENDANCE::status). I have also tried to above suggestion of: "Your attendance list layout will be based on the Services table with a portal to the Attendance table, but also showing the name fields from the Members table.  Most of your data entry will be on a layout  in the Attendance table."  I have not successfully been able to get this to jive.  This is where I just don’t get why it’s not displaying what I want: For EVERY new record in SERVICE, I want to list EVERY member (~ 150) with a blank status next to their name so that a radio button can be pressed, and it will record a new record for that member for that service.  All of the attempts at manipulating the relationship between the tables that I’ve done have resulted in the following: 1)      No names AND no status field show in the portal 2)     No names BUT ONE status field shows on the first line of the portal 3)     One name AND one status field show on the first line of the portal 4)     ALL names AND ALL status fields show in the portal BUT changing the status on the first record changes all of the rest of the statuses on the other lines to that same status.  I do have creation and deletion of records enabled on the "many" side between MEMBER and SERVICE and between SERVICE and ATTENDANCE.  This is because I’ve modified the relationships to be =, not equal, X, etc. but I can’t key upon the one that will get me the results I need.  I am new to FM and I have completed the available tutorials on VTC and other resources, too. Would anyone be willing to help point me in the right direction?

doughemi, Thank you for responding. I will have some time later tonight to try to work on this (after real work stuff) and I'll report back on how well this works or what other issues I might have. Thank you, Jason

Surprise, surprise. I am also a newbie but hopefully I have a softball question for someone just lurking around. Okay, so I originally built a solution for our church directory with the following schema: FAMILY _kp_family_id _kf_member_id last name MEMBER _kp_member_id _kf_family_id first name It was structured like this so that we could do a printed directory page and make use of the portal to just list the first names and their personal cells, email, etc. Now, I'd like to take that solution and also integrate an Attendance chart so that we can take attendance using FileMaker Go and an iPad. This is where the extent of my knowledge begins to be stretched. My goal is for every unique service (Sunday Morning, Sunday Night, Tuesday night, Saturday afternoon, etc.) to have a list that has every members' full name (last, first) and then a group of radio-buttoned statuses next to each of their names. It will look, ultimately, like the attached pdf. I color coded items that I'm guessing will come from a unique table. Will you please help me sort this out? Thank you, Jason Attendance.pdf

Great solution, Jerry. Thank you. Would you be able to assist in getting the text from the Google directions into a field? Thank you, Jason

I am also having the same issues (except on a PC). Have you found your solution?