Add new record doesn't see contactID

[Jana Marcus]

Hi Folks,

I have a large relational database that is three databases all tied to the contact ID. When i go to make a new record in one of the relational bases, it doesn't see the contact ID. Any thoughts?

A professional set this up for me and now even he is stumped. Here's the scenerio:

There's a main contact database. It is tied to a donation database and to a talent database, all are connected by contact ID.

The professional formulated a script so that i can add a new record from the contact view for the donation database. The first "New" record is added just fine. When I want to add a second new record (to the same contact id) it doesn't see the contact id # or info.

what should we do?

Desperate!! thank you!

[Ocean West]

If you are just "creating" a new record in one table/database it will not inherently "see" any relationship to any other table/database, you need to populate the foreign key field of the newly created record to create a common bond or relationship between records.

Most likely you need to copy the correct ID field - if a professional set this up he/she may not be using the field 'Contact ID' to connect the data together but using a field that is not visible to the end users.