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.
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.