Help Needed - Combo Box

[Guest]

Please bear with me whil I try to explain my problem.

I have 3 tables

Table 1 - CompanyDetails
Table 2 - Call History
Table 3 - Info Mem

Table 1 - PK is CompanyID - AutoNumber
Table 2 - PK is CallRefId AutoNumber
Table 3 - PK is IMref - Text field Unique ref typed by user

All 3 tables have the CompanyID field from Table 1 which I set to Number,
Long Integer

Tables 1 & 2 are related on this field as are tables 1 & 3

In Table 2 I set the CompanyID field to be combo box to return the
CompanyName form Table 1 and it works. I typed

SELECT CompanyDetailsTable.CompanyID, CompanyDetailsTable.CompanyName FROM
CompanyDetailsTable;

When I try to do the same for Tabel 3 it doesn't work - I still get the
CompanyID number.

Can anybody tell me why and how I can fix it?

Thanks

Jane

 

[Chris]

Simple solution first.
It couldn't be that the column count is set to 1

OR

The field widths are set to 3;0;0;0 or some thing similar

 

[Guest]

Thank you for replying.

As someone relatively new to Access database creation I have seen the Column
count field and the width settings but don't know what they relate to. I
tried to find something in the microsoft help but wasn't really sure what I
was looking for.

Can you point me in the right direction?

Thanks

Jane

 

[Guest]

Hi Chris

Have been back to the property sheet and have made some progress. Have now
got the ContactID column to return the LastName but not the FirstName
although when I look athe the SQL the 2 fields are there and, when I used the
wizard to create it, it showed the names in both of the columns.(I hope that
makes sense)

The column Count is 3 and the column widths are 0cm; 2.54cm; 2.54cm. I have
also now found the info on these and understand to a degree.

Thanks

Jane