Table Relationships

[landonet]

Hi, i'm trying to create a relationship between 2 tables but i get the following message, any help? "Type mismatch in expression"

 

[Trevor G]

What fields are you using, and what are there Data Types, do they have common information like an ID Field is Primary in 1 table and a number field as a foreign key another field?

 

[landonet]

How can i add an image to show you?

 

[Rabbie]

In the Quck reply boclick on th "Go Advanced" button then scroll down to see the Additional Options. Then click on the "Manage Attachments" button. You'll then see a popup which lets you add the image.

 

[vbaInet]

If you're still struggling with uploading your images, see this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=194680

 

[landonet]

Thanks, my main table is "leads" and everything in my whole database reference back to "business_name" - i want to link my "consumable" table in order to capture consumable sales but the consumable table will get some of the information from the "leads" table, ie "business_name, tel number, etc"

Any help/suggestions will be appreciated...