[FX.php List] Advice Needed - Multiple Portal Entries for record

[Gjermund Gusland Thorsen]

remember that you can construct arrays from for using []

Like this: <input name="portal[345][1]">

ggt667

On 6/13/07, Andrew Denman <adenman at tmea.org> wrote:
> When I have to write multiple related records like this, I take all of the
> information at once on a form and then loop through the data in PHP writing
> them one at a time to FileMaker.  This way the user only has to deal with
> one page.
>
> The only drawback I've found is the time this can take.  Depending on how
> long it takes in your testing and the load you are expecting, you might want
> to have a 'please wait' message.
>
> Andrew Denman
>
> -----Original Message-----
> From: fx.php_list-bounces at mail.iviking.org
> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jon Montgomery
> Sent: Tuesday, June 12, 2007 6:23 PM
> To: fx.php_list at mail.iviking.org
> Subject: [FX.php List] Advice Needed - Multiple Portal Entries for record
>
> Hi,
>     I have a FMP data base that I have been working with since FMP 4.  It
> was basically a flat file with along the way, very very slowly, making the
> change to a fully relational data base.
>     I have managed web entry into the data base via FX.PHP and all worked
> well this past year.  However, entering records is still set up using
> repeating fields for the First and Last Names.  Some records only have ONE
> name where others can have up to 20 (for one of my clients) and even more
> names are possible with my other client (although more than 30 is not that
> common).  About a year ago, I asked a similar question, ggt said forget the
> repeating names and go full relational.  I agree but that leads to the
> following:
>
>     Question:
>
>     Because of the limitations of the WPE only allowing One portal entry,
> how would you go about handling the situation above without having the
> person submit 20 or more times?  Or is that such a big deal to do that,
> enter each name one at a time?  Is there a better way of doing this that I
> am not thinking of?
>
>     Or would it be better to enter using the repeating fields for first and
> last name and then have FM split those out?
>
>     If you want to see the database I can give you a link to download a
> solution.  May not be pretty but works for us! But needs to get  better.
>
>     Any and all advice is appreciated and a BIG THANK YOU up front.
>
> Jon Montgomery
> Illinois Grade School Music Association
> Walking DataBase Solutions
>
> --
> Jon Montgomery
> Web site: www.igsmasouth.org
> Support email: igsmasupport at igsmasouth.org
> Home email: vicepresident at onecliq.net
> School email: jwmontgomery at dqud300.perry.k12.il.us
>
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>