Relationship Problem, This is a hard one for me.

[Dave Elliott]

The main form TimeCards shows the customer and any material used for the job
via the sub-form vendor_list
I have a customers, vendors, vendor_list, CMatSub and timecards form.
On the timecards form the sub-form vendor_list is linked by TimeID
vendor_list form shows the vendor, amount and invoice number for the current
record or timecard.
vendor_list has record selectors, meaning it can have many records on it.
The timecard form which is the main form gets it's customer from the
customer table.

The form vendor_list uses 2 tables, vendorinfo and invoices
The form TimeCards uses 1 table TimeCards
The form customers uses 1 table Customers
4 tables in all.
5 forms
4 queries
2 modules

The customer form has a sub-form named CMatSub which is supposed to show all
the records via the timecard sub-form vendor_list for that customer. (It
does not and this is the problem)

Now I will try to simplify;
If I open the form by itself CMatSub, it will show the 3 fields I need
If I open the customers form with sub-form CMatSub it shows the same records
for each customer record
Forest Gump, a customer has (2) material records on the sub-form and Bubba
Gump has (1)
Both Forest and Bubba's records show up on the customers form for each
record regardless of a different customer.
I am sure it has to do with the Master and Child Link fields, but dont know
how to make it work.

Thanks,
Hope this explains my problem.
You might have to see this db to help me.
If so let me know and I can zip and send, it is small. 980kb unzipped