Unable to See Field from Subform Inside Main Form when in Datasheet View

C

Calzontzin

I have 2 tables, A and B. Table A contains a numeric "CustomerNumber"
field and table B contains the same numeric "CustomerNumber" field as
primary key plus a text "CustomerName" field. There is a many-to-1
relationship between tables A and B respectively for the
"CustomerNumber" field.

I have a form that displays data directly from table A in datasheet
view. What I want to do is to have a column for the "CustomerName"
field from table B for each record in table A. If I include a subform
inside my main form and include the "CustomerName" field in the
subform, the column never appears in datasheet view! If I change the
view from datasheet view to other view (e.g. columnar) then I can see
the customer name field (?).

I want to avoid using queries because, when a numeric "CustomerNumber"
field is missing from table A, then I don't get that record displayed
because of the query.

Any ideas? Thanks!
Calzon
 

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

Similar Threads

Populate main form from subform record 0
How to Create an S-Curve from Custom Field? 0
Dynamic Naming of Form Button 3
Dealing with the error: unable to filter on excel hc home school 0
Copy previous record into form field 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Help creating a search form in Access XP 0
Hidden Field in Datasheet view for a table 5

Top