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

    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:

    relationships are as shown:

    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:

    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?

  2. #2
    Join Date
    Mar 2009
    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