That column with the "+" signs...

[damie]

I know I'm going to explain myself very badly, so I only hope someone knows what I'm getting at:

You have a Table A with columns: Client (Primary Key), Country and Contact and a Table B with columns: Project (Primary Key), Client and Country (for example).

If the relationship between A and B is Client to Client and one to many there appears in the table A a seperate column (with the minute "+" signs) where you can click on each line and all the projects from from table B relating to the client in table A appear on top of the table A.

I have changed the Primary key in Table A from Client to Client & Country (both columns) and creating a one to many relationship with the Client and Country columns from Table B. I assumed that this would mean that I could still click on each line of Table A and see all of the projects that relate to the client and country on the selected line. However, the column with the "+" signs no longer appears so I no longer have this info available with a simple click on the table. I know I can create forms and queries, but I would like to maintain this access. Am I doing something wrong or is it simply that having two columns as the primary key automatically excludes this possiblility?

Hoping someone understands and has the answer,

Thanks.

 

[damie]

Maybe I undestand wrong but this is what I have: (pk - primary key)

Table 1

Client (pk)
Country (pk)
Address
Contact

Table 2

Project Name (pk)
Client
Country
Description
Type

I have a one to many relationship from Client and Country in Table 1 to Client and Country in Table 2. This should therefore work, shouldn't it? I'm lost!

 

[GumbyD]

Damie -

I just did a bit of poking around in a database. It appears that in the table properties you define a child and master link and the subdatasheet Name. Try going into the table in design view right click for the properties and see what if anything is set in those properites. You may have to play around with this to get to work for you. It may be that the sub-table needs those fields to be part of the key.

GumbyD

 

[damie]

Thanks for everyones help. I'm not sure that I follow the last piece of advice. GumbyD, are you saying that Client and Country from Table 2 should be primary keys as well? I have looked at the properties in design mode but don't really see anything to be playing with in respect to this problem. I am a bit useless, though!

What I am playing with is only an example of several tables of a few lines each to work out where I'm going before doing it all properly. If anyone wants to take a look at the programme, I can send over what I have (1.35mb in Access 2000) and hopefully it's just one of those dumb errors where you need someone else to take a look before you can see it.

Thanks again.

 

[GumbyD]

Damie -

Send it over to me!