Search results

lol.......................:D

Thanks heaps ill have a look at this and change my structure. You must be a Kiwi or at least been to New Zealand? yes Farmers is still around. I must stress here that all the info in the test database is made up, ie fictional for testing purposes, just in case i get called up on this by anyone...

please find the database attached. The form i am making is called correspondence. What i am aiming to do is be able to fist select the client name and then select the store i am after and for the form to bring up all the information for this store, so i can look at their sales and add...

Thank you for both replies both helped, the first one i realised i had my main join wrong and corrected. the second on was actually the problem. my main query included both tables and as the second table had lots of different correspondence relating to the first all those instances were coming...

im a bit mift, i have a contact table with data of address's and a store id that is unique. I have connected to this another table with correspondence relating to the store on it. this second table has the store id also and is connected to the first via this. the join says all data from the...

Nope sorry i understand what you are saying and all has worked thanks its been a few years so very rusty. all solved thanks you all very much for your help

"The message is telling you that you are trying to link mismatched keys. If one key is a LONG INTEGER, the other key has to be a LONG INTEGER. If one key is simple, the other key cannot be compound. For some reason, it thinks that one of the keys has more fields in it than the other. The error...

trying to join two tables but get message "relationship must be on the same number of fields with the same data types" data types are same, numbers. Primary table has just jobnoID that are all unique (primary table) ie 6907, 6908, 6909 etc second table "jobs by order" (secondary table) has...