Hi,
I'm absolutly stumped (and more than just a little frustrated) %-( . I have 2 tables that are linked together with a one-to-many relationship. When I open query-builder, I can see all the fields in the first table, and when I bring in the second one they link automatically like the should (sometimes, other times the linking field isn't even present on the field list!!!). I close and save the query as say "Query1" or whatever. When I go to reopen the same query 2 seconds later, I get this error message:
Microsoft Access can't represent the join expression [table1Name].ID = [table2Name].[FieldName] in Design View
* One or more of the fields may have been deleted or renamed
* The name of one or more fileds may be misspelled
* The join may use an operator that is not supported in design view
The linking Field isn't even on the field list for the table!!! I have this same setup in my Test dB and it works fine. I have a replica of this dB on another server, no problem. I'm lost. Any help would be greatly appreciated!!!
I'm absolutly stumped (and more than just a little frustrated) %-( . I have 2 tables that are linked together with a one-to-many relationship. When I open query-builder, I can see all the fields in the first table, and when I bring in the second one they link automatically like the should (sometimes, other times the linking field isn't even present on the field list!!!). I close and save the query as say "Query1" or whatever. When I go to reopen the same query 2 seconds later, I get this error message:
Microsoft Access can't represent the join expression [table1Name].ID = [table2Name].[FieldName] in Design View
* One or more of the fields may have been deleted or renamed
* The name of one or more fileds may be misspelled
* The join may use an operator that is not supported in design view
The linking Field isn't even on the field list for the table!!! I have this same setup in my Test dB and it works fine. I have a replica of this dB on another server, no problem. I'm lost. Any help would be greatly appreciated!!!
