Jave

[Jave]

Hi,

I have a one to many relationship and thus on a form that
has a Main form and a Subform.

PROBLEM:

If I have ONE main record (customer info) and MANY records
(total of 8) relating to the customer the record selector
and counter is showing 8 RECORDS in the subform bar and 8
in the main form BAR too, when I only have one!!!

What am I doing wrong?!?!?!!?

Please Assist!!!
Jave

 

[Ted]

What is the record source for your main form? It sounds
like you may be joining both tables in the record source
for the main form. If that is the case, try using only
the customer info table for the main form recordsource.
The subform should then link to the main form via
CustomerID.

If not, post back with a little more detail on the record
sources for the forms and how they are linked.

-Ted

 

[Jave]

Hi Ted,

I have for the first table PK is Invoice Number and for
the second table PK is RID. The second table of course
has an Invoice Number that I joined it to?

Please and thank you.

Jave

 

[Rick Brandt]

Hi Ted,

I have for the first table PK is Invoice Number and for
the second table PK is RID. The second table of course
has an Invoice Number that I joined it to?

Neither form should be bound to a query with more than one table in it.

 

[Jave]

Thanks!

-----Original Message-----


Neither form should be bound to a query with more than one table in it.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.