locked
Need some serious help....How do I update a backend table from an unlinked frontend table? RRS feed

  • Question

  • The tables from the backend and frontend are same fields.  I can't figure out how to update the backend table with all the changes that were made to the frontend table.  Help please!

    Thursday, January 19, 2012 1:04 AM

Answers

  • First backup both the backend and the frontend - if something goes wrong in the process I describe below, you can always start again from the backups.

    Check in the relationships window to see what relationships exist for the table in question and make a note of any relationships - perhaps a screen shot will give you the info you need.

    You should be able to open the backend and import that table from the front end into the backend. Delete the existing table and rename the new table to the same name as the existing table.  Re-create any relationships that existed for that table - using your notes/ picture.

    Go the the front end and delete that table and then link the front end to that table in the backend.

    Test that data now goes in to the correct tables as expected.



    Jeanette Cunningham
    Thursday, January 19, 2012 1:54 AM
  • The backend table was imported into the frontend, but not linked.  After entering all data through forms, only the table in the frontend gets updated.

    If you import the BE tables into the FE, and when you add,update,edit...the records or table, you are only updating,editing,adding...the FE tables/Records. The BE records have no relation to the FE therefore, nothing is edited,added,modified....in the BE.

    We assumed that you are doing a sample of the records, not a real live DB or the actual DB.

    What you should be doing is to link the Tables not Import. Remove or delete the imported tables (assuming a sample DB) in your FE and do a linking to the BE instead.

    • Marked as answer by Bruce Song Thursday, February 2, 2012 5:50 AM
    Friday, January 20, 2012 1:31 AM

All replies

  • This is a bit of an unusual question. It's important to understand how your database is set up to give you the best and most correct answer.

    Usually in a database, the 'real' or 'actual' table or tables is/are only found in the backend.

    The frontend links to each table in the backend.

    Entering information into the database by forms, automatically puts the data in the tables in the backend.

    The setup you have described - the changes have been made to a table in the front end - are you taking about changes to the data, or do you have a table that has changes to fields in the table?

     

     


    Jeanette Cunningham
    Thursday, January 19, 2012 1:25 AM
  • The backend table was imported into the frontend, but not linked.  After entering all data through forms, only the table in the frontend gets updated.

    Thursday, January 19, 2012 1:30 AM
  • First backup both the backend and the frontend - if something goes wrong in the process I describe below, you can always start again from the backups.

    Check in the relationships window to see what relationships exist for the table in question and make a note of any relationships - perhaps a screen shot will give you the info you need.

    You should be able to open the backend and import that table from the front end into the backend. Delete the existing table and rename the new table to the same name as the existing table.  Re-create any relationships that existed for that table - using your notes/ picture.

    Go the the front end and delete that table and then link the front end to that table in the backend.

    Test that data now goes in to the correct tables as expected.



    Jeanette Cunningham
    Thursday, January 19, 2012 1:54 AM
  • The backend table was imported into the frontend, but not linked.  After entering all data through forms, only the table in the frontend gets updated.

    If you import the BE tables into the FE, and when you add,update,edit...the records or table, you are only updating,editing,adding...the FE tables/Records. The BE records have no relation to the FE therefore, nothing is edited,added,modified....in the BE.

    We assumed that you are doing a sample of the records, not a real live DB or the actual DB.

    What you should be doing is to link the Tables not Import. Remove or delete the imported tables (assuming a sample DB) in your FE and do a linking to the BE instead.

    • Marked as answer by Bruce Song Thursday, February 2, 2012 5:50 AM
    Friday, January 20, 2012 1:31 AM