Help with relationships?

[Guest]

1. I have a one-to-many relationship. But everytime i go back to the
relationship window Access automatically creates another relationship using
the same table on the one-side of the relationship and then adds a "_1" to
the end of the table name (making it different table in the relationship
view). Why is it creating this relationship all over again with a slightly
different table name on the one side??

2. I have a form that uses 2 tables (customer and payments) where you track
customer payments. It was working fine. Now when ever i add a new customer to
the customer table, then i go to add a payment record for them in the
payments form by selecting there name from a drop list on the form it doesn't
change the records below on the payments subform. But when i select another
person who was already in the database it looks up there payment records fine
and i can add a payment record for them with no problem??? Can anybody help??

 

[B Karthick]

Dear Adam,

Reg your 1. question, the table_1 does not exist physically. Just delete it
by selecting it from the relationship window or just ignore it. To be on the
safer side delete the join line first and then delete it.

Best Regards
B Karthick
Access Addict

 

[MacDermott]

1. While curiosity is often a good thing, and can lead to better insights,
in this case I'd suggest just leaving it alone and trusting that Access
knows what it's doing. Unless you have a lot of other relationships, I
can't see how this one extra could hurt anything.

2. Is this what is happening? You have your Payments form open, then add a
new customer in the table. Your new customer doesn't appear in the
Customers dropbox until you close and re-open the Payments form. Is this
correct?

1. I have a one-to-many relationship. But everytime i go back to the
relationship window Access automatically creates another relationship using
the same table on the one-side of the relationship and then adds a "_1" to
the end of the table name (making it different table in the relationship
view). Why is it creating this relationship all over again with a slightly
different table name on the one side??

2. I have a form that uses 2 tables (customer and payments) where you track
customer payments. It was working fine. Now when ever i add a new customer to
the customer table, then i go to add a payment record for them in the
payments form by selecting there name from a drop list on the form it doesn't
change the records below on the payments subform. But when i select another
person who was already in the database it looks up there payment records fine
and i can add a payment record for them with no problem??? Can anybody

help??

 

[Guest]

What hapens is when i select the persons name from the drop down all the
related records show on the subform below from the payments table subform -
that is what supposed to happen. But now i have 2 new customers, who when i
select there name the record set on the subform below (payments table) does
not change - it seems like its not linked...however all the custormer names
work when selected from the drop down - the subform below updates to show
that custormers payment records..

 

[MacDermott]

Has your form been closed and re-opened since the time the new customers
were added?

 

[Guest]

Yes it has. Would it make a difference that neither of the customers have
payment records yet? When i select the name in the main form and they dont
have any records yet in the payments table would it show the empty records
(so you can add one for the first time) in the subform?

 

[Metogo Ndazoa Jean MARIE]

1. I have a one-to-many relationship. But everytime i go back to the
relationship window Access automatically creates another relationship using
the same table on the one-side of the relationship and then adds a "_1" to
the end of the table name (making it different table in the relationship
view). Why is it creating this relationship all over again with a slightly
different table name on the one side??

2. I have a form that uses 2 tables (customer and payments) where you track
customer payments. It was working fine. Now when ever i add a new customer to
the customer table, then i go to add a payment record for them in the
payments form by selecting there name from a drop list on the form it doesn't
change the records below on the payments subform. But when i select another
person who was already in the database it looks up there payment records fine
and i can add a payment record for them with no problem??? Can anybody

help??

 

[Guest]

Yes it has. I checked the links and they exist (actually if they didn't
wouldn't the others not work either? Links encompas the entire Main form to
the subform why would some work and others not?). The subform properties are
also set to allow deletions, additions, etc.. Any other suggestions..does it
sound like the form can be corrupt? I added a few more new customers and even
when i directly add one payment record into the payment record so that when i
go into the form and lookup there payments by name it shows up - doesnt work
either and the customer id is not changeing when i select a new customer.
When i look at the customer table data the id's are different. doent
understand what is happening?