Search results

Hello Everyone. I have a form which consists of multiple tables. I have outer join relationship between the tables. The foreign keys are on the form. Every time I try to enter a value in the foreign key, I get this error message: "The current field must match the join key "?" in the...

Hello everyone. My form consists of multiple tables. All the tables have one to many relationship. On my form, the tables have outer join relationship. I have two problems: 1. I have foreign keys on my form that are automatically indexed. How can I stop that? 2. I have outer join...

Hi. I have a form based on multiple tables, with one to many relationship. In the form query, I have an outer join relationship between the tables. In my one side tables, my primary keys are Autonumber. On my form, my joining fields are coming from my foreign keys. As soon as I start...

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