Sub-form breaks when adding query

  • Thread starter Thread starter SJM
  • Start date Start date
S

SJM

I have two related tables (Brand and DealStructure) that I also use in a
form/sub-form. The DealStructure form is the sub-form in Datasheet mode with
the Brand form. I want to add a field within the DealStructure sub-form that
concatenates the first four letters of the brand field in the Brand table
with the dealdate field in the DealStructure table. I was successfully ably
to do this in a query, but once I added that field to the DealStructure
sub-form the relation went sour - it displayed all records (related or not)
in the sub-form.

1) Did I explain this well enough? I am an Access amateur, so I am not sure
if I used the correct terms
2) What is the best way to accomplish my goals?

Steven
 
Hmmm! For me, I would need a little more info. I'd like
to see your tables and query. I see only two fields in
your two tables: Brand and DealDate. How many letters
are in the Brand field? What are the datatypes of these
two fields? You may be trying to concantinate fields
with differing datatypes.

Answer to your two questions: #1. I don't think so. #2.
Read Access books, searches on the web and this
newsgroup, and practice, practice, practice. MS Access
is NOT easy!

Denny G.
 
Denny:

I was able to concatenated using a Query, that's not where the problem
exists. The problem is once I use the Query with the newly concatenated
field the relationships break.

Steven
 
I understand. I am suspicious that what you are doing is
fundamentally wrong starting in the tables and query.
But without further info, I am lost. Maybe one of the
gurus in this newsgroup can give you an answer.

Denny G.
 
Back
Top