Challenge Establishing Relationship

Discuss the database features
Post Reply
DonGatto63
Posts: 1
Joined: Fri Mar 01, 2019 4:39 am

Challenge Establishing Relationship

Post by DonGatto63 »

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
FJCC
Moderator
Posts: 9274
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Challenge Establishing Relationship

Post by FJCC »

I assume VendorName is a text column and VendorID is an integer. Try connecting the VendorID columns in the two tables.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Post Reply