Changed data

  • Thread starter Thread starter Cyndi
  • Start date Start date
C

Cyndi

I have a database that consists of my tables and some tables that are
linked from another database. When an entry is changed in the linked
tables the attached info isn't moving also for instance

Horse A is attached to season A and has a payment applied
Horse A is reattached to season B but when it is changed the payment
doesn't move to B
 
Cyndi said:
I have a database that consists of my tables and some tables that are
linked from another database. When an entry is changed in the linked
tables the attached info isn't moving also for instance

Horse A is attached to season A and has a payment applied
Horse A is reattached to season B but when it is changed the payment
doesn't move to B
Click to expand...

More information. What are the join properties? What kind of link
(one-one one-many etc.) Which tables are in which database (local vs.
remote).
 
What do you mean Horse A is reattached to season B. Are these table names,
field names, or database names?

Please explain your process of entering data. It is not clear what you are
doing.
 
Thanks for trying to help - let me see if I can explain this better -
be patient please I am pretty new at this


One Table has all the seasons for a stallion so it would have SSN ID
and then the stallion #, mare #, share # etc this is a linked table

the other table has all the commissions for these seasons - each
season can only have 1 or 2 commissions - the table has a commission
id, ssn id, stallion #, mare #, etc

at different times it becomes necesarry to change the ssn # so you can
go into the form, make a new share, put your mares name in the field
and it then make a new ssn id and move the info to that new ssn id

somehow in my linking when it does this it doesn't change the ssn id
in the commission table - that table is still reading the original ssn
id

is there a way to update the commission table for the new ssn id is
what I am trying to do?
 
Back
Top