field missing from table view

G

Guest

I have two tables that are related. The second table has a many to one
relationship with the first. In case I worded that wrong, the first table can
have many records in the second table, but each record in the second table is
only related to one record in the first.
In design view and relationships view, the linked field is visible. When I
open the linked second table, the first table's linked field does not appear.
In other words:
Design View for 2nd Table
Contract Auto-number, Primary key
Company Number
Date Date
(etc.)

Table view:
Contract Date (etc.)

Why doesn't the one field show? The other fields all do. Thank you.
 
R

Rob Parker

The only thing that springs immediately to mind is that you've somehow
managed to hide the column for that field (perhaps by dragging the width to
zero). With the table open (in datasheet view, not design mode), from the
Format menu, select Unhide Columns ...

HTH,

Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top