oscarbum Posted December 8, 2005 Posted December 8, 2005 Giving that this is my third database I'm creating for a business, it is REALLY embarassing that I CANNOT figure out why these two databases are not sharing data. The relationship is built in both databases, the related fields are in place. Everything is indexed that needs to be and yet, I'm looking at layouts with blank fields. I know I've missed something simple and I'm going to hide all sharp objects when I read the response. Thanks in advance.
stanley Posted December 8, 2005 Posted December 8, 2005 Oscar: It's tough to say without more detail. The first thing to check is that your match fields actually match. In other words, if your relationship is based on the field Serial_Number in Database_A matching with the field Parent_Record in Database_B, do those fields actually contain the same data? Are they the same type (i.e., number, text, date, etc.)? -Stanley
oscarbum Posted December 8, 2005 Author Posted December 8, 2005 No. It was dumber than that. But it's fixed. Of course, I find the problem about 30 seconds after the post and laboring for 2 hours.
BrentHedden Posted December 9, 2005 Posted December 9, 2005 I wish I had a count of how many of my own postings I figured out soon after.
Recommended Posts
This topic is 6982 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now