Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jun 2004
    Thanked 0 Times in 0 Posts

    Table Update (2003)

    I have a form which contains a subform. The subform is populated with the following query:

    SELECT BOL.[BOL Number], BOL.[BOL LBS], [Beelman Invoice BOLs].[Beelman BOL Number], [Beelman Invoice BOLs].[Beelman LBS], IIf([BOL Number]=[Beelman BOL Number],Yes,No) AS [BOL # Match], IIf([BOL LBS]=[Beelman LBS],Yes,No) AS [BOL LBS Match], IIf([BOL Number]=[Beelman BOL Number] And Not [BOL LBS]=[Beelman LBS],No,Yes) AS [BOL Match]
    FROM BOL INNER JOIN [Beelman Invoice BOLs] ON BOL.[BOL Number] = [Beelman Invoice BOLs].[Beelman BOL Number];

    There is a relationship between the BOL Number field in the BOL table and the Beelman BOL Number field in the Beelman Invoice BOLs table.

    In the subform, I want to be able to change the BOL Number field and it update in the BOL table and not update in the Beelman Invoice BOL

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Table Update (2003)

    I cannot visualize what you are doing. You'll need to explain much more fully and clearly, for example: what is the main form based on, how is the main form related to the subform, why is the subform query based on two tables, why do you want to modify the field on which those two tables are joined? Etc. etc.

Posting Permissions

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