Explore BrainMass
Share

Explore BrainMass

    MS Access 2013 Form processing multiple tables

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Have a database for which Im trying to create a form to input the same data for multiple instruments at the same time, with no luck. For now just trying to get GC 2 and GC 5 on the same form to input the data - I have started the form (Fm_GC) and would like for it to be workable, and for data to go to their respective GC_ Perf tables. Is there any way to do this?

    Please see attached file.

    © BrainMass Inc. brainmass.com May 20, 2020, 11:24 pm ad1c9bdddf
    https://brainmass.com/computer-science/data/ms-access-2013-form-processing-multiple-tables-568710

    Attachments

    Solution Preview

    Dear Student,

    I have gone through your project. It is not possible to do it exactly the way you have started your form. If the data resides in different tables you need to use sub-forms. A form can be bound to just one table. However, I have taken another approach. I have created a query "MyUnion" that joins all of ...

    Solution Summary

    An MS Access Database contains several performance tables. They are joined by query and a entry form is created with search filter.

    $2.19

    ADVERTISEMENT