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

Jon Montgomery igsmasupport at igsmasouth.org
Tue Jun 12 17:23:14 MDT 2007


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




More information about the FX.php_List mailing list