Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Unanswered: Lookup field relationships in adding data to table from query

    I have a query that I am using to filter and add entries to a table. Query setup is as shown:
    Image

    relationships are as shown:
    Image

    when I try to add an entry, 'Desc', 'MFGName' and 'Unit' Fields are all automatically populated based on the 'PN' selection. User selects 'DWGNumber', 'ItemNumber', 'QTYProto' and 'QTYProd' in the query:
    http://fud.community.services.suppor...4-b2204d591deb

    This then adds an entry to the Wiring Table, but the MFGName field does not match the PartsNames table or the value put in the query. How can I make sure this field updates properly?
    http://fud.community.services.suppor...1-f570c080d179

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Please post the SQL expression of the query (queries) as well as information about the table(s) structure (name, columns names and data type).
    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •