Relationship Tables/Queries

[Guest]

Hi,

I wanted to know if anyone knew how updating a table that has many
relationships with most recent information via Qry, connectiong via an ODBC
to pull data. We would like to remove data from our client table and maintain
the relationships when data is brought back into the table.

Example:
I have created a note screen form so that the collection team can keep track
of the incoming and outgoing calls to our clients, once a note is entered and
when we try to update our records with the new information the records that
have a note attach to the clients account will not update, because of the
note that was entered. Is there a way to update those records that have notes
attached to their accounts.

Thanks for your help, I hope the message is understandable
Sheria

 

[Jeff Boyce]

Sheria

Access works on data stored in tables. You've described screens ("forms"),
but not how your data is structured/related.

Please describe your data/table structure (what information you're storing
in which tables). An example might help...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

The information that we are pulling is from a Unix Database, the unix
database stores all of our client information, but we wanted to create an in
house database for our staff to keep better track of all the clients that are
calling and all the information that the collectors receive from the client.
We have linked a tblClients from the Unix database to a tblNotes so the
tables are linked by the client ID number once the ID number is entered into
our access database then all the client info that we pulled from the unix
database will pull up. When we have to enter a note into the system the
client ID number is already setup in the Notes Table because of the Client ID
being our link. We are having a problem with being able to pull the clients
updated information into our access database that have a note entered into
our access database from the Unix database system. We need to update the
access database daily from the Unix database since this is the system that is
use by all our other location.

I hope that what i just typed was understandable for everyone
Thanks for your help
Sheria

 

[Jeff Boyce]

Sheria

I can't tell if your Access db uses links to the Unix db tables or imports
from it.

Your use of the word "linked" sounds like you are describing the Primary
Key/Foreign Key relationship, not the linked table vs. local table.

I still don't have a clear picture of your (Access) table structure.

I still can't tell what is happening when you try to import data (?error
message? ?nothing at all? ???).

More information, please...

Jeff Boyce
Microsoft Office/Access MVP

 

[Pedro Jose Martinez]

proba

The information that we are pulling is from a Unix Database, the unix
database stores all of our client information, but we wanted to create an
in
house database for our staff to keep better track of all the clients that
are
calling and all the information that the collectors receive from the
client.
We have linked a tblClients from the Unix database to a tblNotes so the
tables are linked by the client ID number once the ID number is entered
into
our access database then all the client info that we pulled from the unix
database will pull up. When we have to enter a note into the system the
client ID number is already setup in the Notes Table because of the Client
ID
being our link. We are having a problem with being able to pull the
clients
updated information into our access database that have a note entered into
our access database from the Unix database system. We need to update the
access database daily from the Unix database since this is the system that
is
use by all our other location.

I hope that what i just typed was understandable for everyone
Thanks for your help
Sheria

 

[Guest]

Our Client Table is the link between Access and Unix. The Client Information
is pulling directly from the Unix Database, we set up the ODBC to pull the
client information. Once well pulled that information to the Access table, we
used the Client ID number as the Primary Key and the Client Table, Notes
Table, and Insurance Request are all linked by the Client ID. Once the client
id is entered in either table/form the client information that was pulled
from the Unix Database will be displayed to the users.

Example: If a client was to call in regarding their account information, the
collectors will access the Unix Database and pull of the client information,
once they pull up the clients information they will keep track of the
incoming, outgoing and return calls in Microsoft Excel, but since we created
this Collections Database to keep track of all the clients information, when
the client calls in the collectors will only have to access the access
database program that has be created, the information that is being pulled
from the Unix Database will appear once the client id number is entered into
the access database, so the same info is being displayed just on a different
database.

Our problem is once we enter the notes regarding the clients call into the
access database we are unable to do an import update in access, because all
the clients information will not update if a note has been entered into the
system, only the clients that do not have any notes entered in the access
database will be updated. We need all the clients account to update
regardless if there is a note added into the system.

After we try to do a import update from the Query Screen the access database
double in size we have to use the compact and repair to shrink the program so
it will not take up to much space.

The unix system that we are currently using will fade out with in next few
years and we just need to have something that is user friendly to replace it.

I hope that this message is better understandable then the last two. This is
the best way i can explain it.

Thanks for your help
Sheria

 

[Jeff Boyce]

Sheria

I still can't quite tell if the data is in Access, or is merely a link to a
table that is in Unix. I think you're saying that you download data from
Unix into a table that exists locally in your Access database.

Since we don't have your database in front of us, it's pretty difficult to
determine what it is doing when it tries to download information, or tries
to download after Notes have been entered. Are you getting error messages?
If so, what do they say? If you don't get error messages, what happens?

Without more specifics about what your code/macros/queries are doing, and
your data (table) structure, and how you are adding Notes, and what happens
when what you are trying fails, it will be tough to offer specific
suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP