Jump to content
Sign in to follow this  
louflis

Rebook

Recommended Posts

 

 

I have an accommodations/ticket order database. I would like to setup a rebooking system where a person could rebook in advance their accommodation/ticket package for the next year. I duplicated the database and named it REBOOK. The problem I am having is that if there is a change in their order in REBOOK and want to update information in the order form, it does not update when I import the changed info.  Any thoughts Basically what I want to do is add an updated order. There are two related tables - KB 16 & ticketOrd.   (See attached)

T

rebook_Pic.jpg

Share this post


Link to post
Share on other sites

Why create a duplicate database? A re-book is simply another booking, with the same characteristics as the original except a different date, surely??

Share this post


Link to post
Share on other sites

Yes, what webko said. In addition, why would you change an old order when you rebook?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Similar Content

    • By SebLetarte
      Hello,
      We have a solution to store pictures(JPEG and NEF) from a photographer. I am trying to mass import the raw files(.NEF) into containers but I have an error message saying 'This file could not be translated using the selected file type'.
      It is possible to drag and drop or File->Insert the file into the container directly but I can't import them from the folder.
      Is this impossible to import files from folder with extensions other than the basic ones? (jpeg, pdf, jpg, png etc)
      Thanks!
    • By fm8443
      I have a script to import an Excel file into an FM Table.
      I have my FM Script setup to Import Records with Arrange by: LAST ORDER.
      But it won't do this.  Every time I run this script it gets the field mappings wrong.  Reverts them back to before.
      Ironically when I do it manually it works.
      Any ideas?  (I have this type of scripted import working fine for other tables)
      (I tried shifting the order of the fields in the actual database table as well -- but that has no effect either.)
    • By fm8443
      I am trying to open my (local) FM 14 Pro file [which has an auto-exec "Import Script"] but the script needs a variable file name.
      How do I pass this variable file name into Filemaker at 1) the time of the file open or 2) at the time of running the script (if I switch to manual execution)?
      Is #1 by using the fmp:// syntax from a web browser external to FM?  (or is that syntax just for use when invoked from INSIDE a FM file?)
    • By Linda L
      Environment:  Windows 7 with FileMaker Pro 14.
      I have a test database that I am currently making changes to.  I saved the test database as a clone, so that I could test importing data back into it.  the Import functions allows me to import the first table of information just fine, but it will not let me import any other tables.   On any subsequent import, I can select the source table from my source file, but all of the target files are grayed out, except for the first file to which I was able to import into.  What am I doing wrong?  I will need to do this on a regular basis, as I will use this technique to move my changes into the live environment.
      Thanks,
      Linda
    • By epatrick
      I need some help importing a RSS 2.0 XML into FileMaker Pro Adv 10. I'm trying to modify a xslt file that came with FM. When I use this xslt it tries to map the parent Recipients and not the child Recipient.  I'm stuck and could use a hand.  Any thoughts on what to modify or add would be much appreciated?
      Here is the xlst:
      <?xml version="1.0" encoding="UTF-8"?>
      <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
      <!--
      File: msdso_elem.xslt
      Transforms data in an ELEMENT based MSDSO grammar
      into the FMPXMLRESULT grammar, suitable for import.
            
      ===============================================================
      Copyright © 2002 FileMaker, Inc.
      All rights reserved.
      Redistribution and use in source and binary forms, with or
      without modification, are permitted provided that the following
      conditions are met:
      * Redistributions of source code must retain the above copyright
        notice, this list of conditions and the following disclaimer.
      * Redistributions in binary form must reproduce the above copyright
        notice, this list of conditions and the following disclaimer in
        the documentation and/or other materials provided with the
        distribution.
      * Neither the name of the FileMaker, Inc. nor the names of its
        contributors may be used to endorse or promote products derived
        from this software without specific prior written
        permission.
      THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND
      CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES,
      INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
      MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
      IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
      ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
      CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
      SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR
      BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY,
      WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
      NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
      SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
          
      ===============================================================
      -->
             
          <xsl:template match="/*">
              <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
                  <ERRORCODE>0</ERRORCODE>
                  <PRODUCT BUILD="" NAME="" VERSION=""/>
                  <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="{count(/*/*)}" TIMEFORMAT="h:mm:ss a"/>
                  <METADATA>
                      <xsl:for-each select="/*/*[position()=1]/*">
                          <FIELD>
                              <xsl:attribute name="EMPTYOK">YES</xsl:attribute>
                              <xsl:attribute name="MAXREPEAT">1</xsl:attribute>
                              <xsl:attribute name="NAME"><xsl:value-of select="name()"/></xsl:attribute>
                              <xsl:attribute name="TYPE">TEXT</xsl:attribute>
                          </FIELD>
                      </xsl:for-each>
                  </METADATA>
                  <RESULTSET>
                      <xsl:attribute name="FOUND"><xsl:value-of select="count(child::*)"/></xsl:attribute>
                      <xsl:for-each select="child::*">
                          <ROW>
                              <xsl:attribute name="MODID">0</xsl:attribute>
                              <xsl:attribute name="RECORDID">0</xsl:attribute>
                              <xsl:for-each select="child::*">
                                  <COL>
                                      <DATA>
                                          <xsl:value-of select="."/>
                                      </DATA>
                                  </COL>
                              </xsl:for-each>
                          </ROW>
                      </xsl:for-each>
                  </RESULTSET>
              </FMPXMLRESULT>
          </xsl:template>
      </xsl:stylesheet>
       
       
      Here is the XML:
      <?xml version="1.0" encoding="utf-8"?>
      <rss version="2.0">
          <Recipients>
              <Recipient>
                  <First_name>Adam</First_name>
                  <Last_name>Smith</Last_name>
                  <Address1>123 main street</Address1>
                  <Address2 />
                  <City>Lakewood ranch</City>
                  <State>NY</State>
                  <Zip>10012</Zip>
                  <Country>USA</Country>
                  <Cust_Phone>941-555-1212</Cust_Phone>
                  <Company_name />
                  <L_num>Z3116-01</L_num>
                  <Qty>50</Qty>
                  <Promo>G147571</Promo>
                  <Toll_num>1-888-238-0030</Toll_num>
                  <email>sample@aol.com</email>
                  <email2>bobjones@adt.com</email2>
                  <repName />
                  <repPhone />
                  <CustomText>Adam Smith</CustomText>
                  <IntOrderId>230839</IntOrderId>
                  <OrderDateTime>2015-10-07 14:26:44</OrderDateTime>
              </Recipient>
          </Recipients>
      </rss>
  • Who Viewed the Topic

    4 members have viewed this topic:
    MonkeybreadSoftware  LatinaGem  dkey  ggt667 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.