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 relationships between tables. Whenever I enter a value in foreign key field on a form, I get an error that this key doesn't exist in the one side table, but IT DOES.
Thanks.
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 relationships between tables. Whenever I enter a value in foreign key field on a form, I get an error that this key doesn't exist in the one side table, but IT DOES.
Thanks.
