Challenge Establishing Relationship

Discuss the database features

Challenge Establishing Relationship

Postby DonGatto63 » Fri Mar 01, 2019 4:55 am

I've been trying to link these two databases, so that I can enter the VendorId in the Inventory - Molds database form, and it will populate the VendorNane into the MoldMaker part of my form. I'm getting the following error:

SCREEN CAPTURE
https://photos.app.goo.gl/J55CbkpWNbeF5kxk7
OpenOffice 4.1.5 on Windows 10
DonGatto63
 
Posts: 1
Joined: Fri Mar 01, 2019 4:39 am

Re: Challenge Establishing Relationship

Postby FJCC » Fri Mar 01, 2019 6:28 am

I assume VendorName is a text column and VendorID is an integer. Try connecting the VendorID columns in the two tables.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7262
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA


Return to Base

Who is online

Users browsing this forum: No registered users and 4 guests