Search results

Richard, u have to follow the solution that Microsoft is suggesting: create a subform. since u will need to use those attachments again, create a table where u want those attachments to be stored. u will need a primary key to identify those attachments. in other tables u can use that key...

Richard, u have to follow the solution that Microsoft is suggesting: create a subform. since u will need to use those attachments again, create a table where u want those attachments to be stored. u will need a primary key to identify those attachments. in other tables u can use that key to...

Found out the cause of the problem, but not the solution. I had attachments fields in my one side table. After I removed the attachment fields from my form (not the tables), I stopped getting the error "The current field must match the join key in the table . . . " To get more information on...

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

Thanks Pat. I think my relationships are fine. NDAs, PSAs, SOWs, and Proposals are documents. Each P02 Form contains all these documents. But sometimes they are not supposed to be on P02. If P02 doesn't contain one of these documents, then I don't want it to be on P02. One same document can...

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