Outer Join - Stop Auto Filling on Form

User2007

New member
Local time
Yesterday, 17:29
Joined
Aug 14, 2012
Messages
8
Hello Everyone.

I have the following tables:
P02
NDAs
PSAs
SOWs
Proposals

Relationship between P02 and rest of the tables are one to many.
P02 is many sided and rest of the tables are one sided.

I have a form where fields are coming from all these tables.
Look at the file Form.jpg

NDA ID, Unsigned PSA ID, Unsigned SOW ID, and Blank Proposal ID fields are coming from P02, while rest of the associated fields are coming from the other tables: NDAs, PSAs, SOWs, Proposals.

The tables are related through these ID fields.
The ID fields are auto numbered in their primary tables.

The relationship between P02 and the other tables is outer join:
Include All Records from P02 and only those records from SOWs/PSAs/NDAs/Proposals where the joined fields are equal.

The problem is that whenever I am about to enter something into the form, the NDA ID, Unsigned PSA ID, Unsigned SOW ID, and Blank Proposal ID are auto filled. (Look at Form Data Query.jpg).
But I don't want them to be autofilled. I want them to be left blank if there is no joining field.

How do I fix my problem?

Thanks.
 

Attachments

  • Form Data Query.jpg
    Form Data Query.jpg
    59.6 KB · Views: 122
  • Form.jpg
    Form.jpg
    74.4 KB · Views: 126

Users who are viewing this thread

Back
Top Bottom