none
Help (relationship) between tables

    Question

  • Good morning,
    Would greatly appreciate it if you can help me ...
    I have three tables:
    1 customers;
    1 batch type 001 or 002 and so on;
    1 Computer.
    This computer will be evaluated on 30 types of stages of analysis that are in a specific table and these phases of each computer must also be related to the computer to be recorded as well.
    All three tables are loaded with data as well as the phase table
    What I wish  is to make a selection of each item and popular in a table entry, that is, this table will control all entrances to every computer within a batch for each client.
    How can I do this without any duplication of data in the input table? How would the relationship be and I have got to use Join to enter in the entrance table?
    Again I thank a lot to help ...
    Marcos
    Friday, October 11, 2013 3:57 PM

All replies

  • It would help if you could provide schema definitions for your 3 tables

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Tuesday, October 15, 2013 3:20 AM
    Moderator