> From: Kevin Tarr <[EMAIL PROTECTED]> > > Any users? This program is outside my experience. I can work with Access, > but it never does exactly what I want. I can't use any other programs, > unless there is something simple I'm missing. > > I'm going to call them objects, hope this will be easy to follow: > > Object A has two properties: it's name (or ID) and description. There are > about 250+. > Object B has ten properties: it's name (or ID) and description, four other > important and four not important (but need tracked). There are 7100+. > > Object C is a reference of one Object A and one Object B. It only has a
> name. There are 7700+. All Object A are used; more than half Object B are > used. There are a few Cs that have the same A and B, but not many. In this > table I need to list C, all the A info, and the important B info. > > That's where I am now. I have a text document that lists C with its A and > B. (I also have two documents that have all the A and all the B info.) I > get Access to build the A table and the B table. When I build the C table, > it recognizes that there are multiple A and B and tries to build lookup* > tables for them. If I let that happen it looks nice, but it won't have all > the A or B info, just the names that came in with C. If I try to do it > manually (I say manually, but I want Access to do it for me) it won't > properly link the info. Or I get errors. > > *(The lookup tables that Access builds for itself, I can't type manually. > It has expressions like xyz_ID_xyz, but no help as to what that means and > no way to duplicate it.) > > Do I need to look at relationships differently, or use Queries to track the > C data I want? > > If someone could help just on this, it'd buy you a liquid refreshment if > you are ever within ten feet of me. It'd be nicer if I could e-mail you > from work tomorrow. > > > It gets worse. The next step is object D. D lists the Cs that are being > used. A D can have many Cs, but never a repeat inside a D. Ds are not > equal. Some are production, some are test and some are unused but exist. > (There is other D info, but not important.) > > I want to backwards track what Cs, Bs and As are being used. If a C, B, or > A has just one instance of being in production, I want it flagged that way. > If not in production but in test, marked so; if not in production or test > but still listed in a D; and the rest not used at all. > > Lastly as a D is added, things are updated, if something unused becomes > used for example. > > Thank you in advance Sound like you don't understand pointers or pointers to pointers. As a simplified example say we have an array 'A' with 10 integer variables (data) A[10]. you also have an array 'B' size 10 integer variables B[10]. You also have an array 'C' that is size 30 integer variables C[30] that contains (points to) 2 integers for each of the thirty variables (multiple-dimensions) C[30][2]. FREX you want to know what the 17th index into array C means. C[17][1] points to data into A specifically A[3], and C[17][2] points to data in B specifically B[7]. A[3] is data =799, and B[7] = -123. C[17][1] = 3 C[17][2] = 7 A[3] = 799 B[7] = -123 So therefore ImportantVariable1 = A[C[17[1]] = 799 ImportantVariable2 = B[C[17[2]] = -123 What it boils down to is you have data that is pointing to other data, indirectly. THerfore if you know that you want data from Table C, you know that C points to Data in A and A points to the Data you want. Therfore if you know what Key / Name / Index you want, TABLE C gives you all the information you need to directly access the information from TABLE A. Etc. _______________________________________________ http://www.mccmedia.com/mailman/listinfo/brin-l
