December 8, 200520 yr 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.
December 8, 200520 yr 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
December 8, 200520 yr Author 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.
Create an account or sign in to comment