By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,434 Members | 2,963 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,434 IT Pros & Developers. It's quick & easy.

Append Reverse Cross Reference?

misscrf
P: 13
I have a table that acts as a cross reference to related records. No we can't get different data, no we have no control over what we have, we just need to be able to manage what we have been given. lol


Anyway, what I have created so far is working well. I have a subform on a tab of a main customer entry form. It says "related customers".

My issue is this: When you go to one record, you may see 4 customer records relating to it. If you go to any of those 4, you only see the first record, as if it is a master.

I am wondering if there is a way to right a query, that can update the table to populate all relationships.

Here is what it looks like now:

CustomerID RCustomerID
33219 242110
33219 242111
33219 242112
33219 242113
242110 24219
242111 24219
242112 24219
242113 24219

So when I am on record 33219, I see that 242110, 242111, 242112, and 242113 are related. But, if I go to any of the records for 242110, 242111, 242112, or 242113, I only see that 33219 is related. I would like to see that 242110, 242111, 242112, and 242113 are related too.

I would like the table to look like this:

CustomerID RCustomerID
33219 242110
33219 242111
33219 242112
33219 242113
242110 24219
242110 242111
242110 242112
242110 242113
242111 24219
242111 242110
242111 242112
242111 242113
242112 24219
242112 242110
242112 242111
242112 242113
242113 24219
242113 242110
242113 242111
242113 242112

I can see it in my head (along with a monkey and a clown on a unicycle...) but I can't figure out how I would write this in what I would think would be an append query. Any thoughts?

Thanks!
Aug 20 '07 #1
Share this Question
Share on Google+
1 Reply


Rabbit
Expert Mod 10K+
P: 12,366
I would, instead, set up my Forms like this:

Have the main form use a query that pulls the Base ID so that you have both Customer ID and Base ID from the related IDs.

Then set up the subform to use the Base ID instead of the Customer ID.

Because if you go the route you're proposing, you're talking a lot of bloat and repeated information.
Aug 20 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.