First let me say I so dearly appreciate the help. I feel like something is right in front of me and I can't see it.
> Two things come to mind: > 1. Are there required fields which are NOT getting data (NULL is somewhat > difficult to pass TO FMP even if it's allowed). And/or are the field types > getting the correct data (timestamps, for example, need date and time). > > 2. Are you binding table occurrence or table to the field/column in the query: > > Table.fieldName > TOname.fieldName In this case once I got the Dev Studio to see the DB properly I simply used the New Record Builder and put fields over to make the quick and dirty test. SImplest use of the Dev Studio. I figured it was safest for the test. I tried using required fields on one test and even if the fields were filled I got required fields errors. So I built a new one with NO required fields just to get past that and make a DB work and that is where I am with now. > Any chance you can post the actual query? (change the data, but try to > maintain the same structure of the query) > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/REC-html40/strict.dtd";> <html> <head> <meta name="security" content="public" /> <meta name="generator" content="Witango Dev Studio" /> <meta name="author" content="Witango New Record Builder" /> <meta name="robots" content="index,follow" /> <meta name="abstract" content="" /> <meta name="description" content="" /> <meta name="keywords" content="" /> <title>New Record Form</title> <style type="text/css"> table { border: 0px solid; margin: 0px; padding: 0px; empty-cells: show; } table th { border: 0px solid; } table td { border: 0px solid; } </style> </head> <body> <form method="post" action="<@cgi><@appfile>?_function=insert&<@UserReferenceArgument>"> <table> <tr> <td>First Name:</td> <td><input name="pubradiopledge_First Name" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Last Name:</td> <td><input name="pubradiopledge_Last Name" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Email:</td> <td><input name="pubradiopledge_Email" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Partner/ Spouse First Name:</td> <td><input name="pubradiopledge_Partner/Spouse First Name" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Partner Spouse Last Name:</td> <td><input name="pubradiopledge_Partner Spouse Last Name" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Type of Membership:</td> <td><select name="pubradiopledge_Type of Membership" size="1"> <option value="New Member" selected="selected">New Member</option> <option value="Renewing Member">Renewing Member</option> <option value="Additional Gift">Additional Gift</option> </select></td> </tr> <tr> <td>Amount of Pledge:</td> <td><input name="pubradiopledge_Amount of Pledge" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>One Time Charge?:</td> <td> <input name="pubradiopledge_One Time Charge?" type="radio" value="One Time">Charge this amount one time <input name="pubradiopledge_One Time Charge?" type="radio" value="Installments">Break this amount into 10 installments <input name="pubradiopledge_One Time Charge?" type="radio" value="Sustaining">Charge each month (create a sustaining plan)</td> </tr> <tr> <td>Type of Payment:</td> <td><select name="pubradiopledge_Type of Payment" size="1"> <option value="" selected="selected">Select type...</option> <option value="Visa">Visa</option> <option value="Mastercard">Mastercard</option> <option value="Discover">Discover</option> <option value="American Express">American Express</option> <option value="Please Bill ">Please Bill Me</option> </select></td> </tr> <tr> <td>Credit Card Number:</td> <td><input name="pubradiopledge_Credit Card Number" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Expiration Month:</td> <td><select name="pubradiopledge_Expiration Month" size="1"> <option value="">Select Month</option> <option value="1">1</option> </select></td> </tr> <tr> <td>Expiration Year:</td> <td><select name="pubradiopledge_Expiration Year" size="1"> <option value="" selected="selected">Select Year</option> <option value="2011">2011</option> <option value="2012">2012</option> <option value="2013">2013</option> <option value="2014">2014</option> <option value="2015">2015</option> <option value="2016">2016</option> <option value="2017">2017</option> <option value="2018">2018</option> <option value="2019">2019</option> <option value="2020">2020</option> </select></td> </tr> <tr> <td>Cardholders Name:</td> <td><input name="pubradiopledge_Cardholders Name" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Street Address:</td> <td><input name="pubradiopledge_Street Address" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Street Address 2:</td> <td><input name="pubradiopledge_Street Address 2" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>City:</td> <td><input name="pubradiopledge_City" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>State:</td> <td><input name="pubradiopledge_State" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Zip:</td> <td><input name="pubradiopledge_Zip" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Daytime Phone:</td> <td><input name="pubradiopledge_Daytime Phone" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>Comments:</td> <td><input name="pubradiopledge_Comments" type="text" size="40" maxLength="0"></td> </tr> <tr> <td>May We Thank You On Air?:</td> <td><select name="pubradiopledge_May We Thank You On Air?" size="1"> <option value="Yes" selected="selected">Yes</option> <option value="No">No</option> </select></td> </tr> </table> <input type="submit" value="Save"> <input type="reset" value="Reset Values"> </form> </body> </html> Chuck Leavens Leavens Media Associates LLC 1919 Riggs Rd Pittsburgh PA 15129 ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe witango-talk" in the body.
