Transfer data from one database to another

  • Thread starter Thread starter VIDDOM
  • Start date Start date
V

VIDDOM

I am a begginer, please be patient.
I have a database called EVENTS, there I have a form which
has a field called "CLIENT" which shows me each client, and
other YES/NO fields showing his or her status: "INACTIVE"
and "CANCELLED".
I also have another database called FOLLOWUP where I have a
form which has a field called "NONCLIENT".
How can I send automatically all the related information
from the database EVENTS to the database FOLLOWUP just by
clicking in the Y/N-field-"CANCELLED"?
Consider:
1.The data will be transfer to tha database FOLLOWUP and
all records in the database EVENTS will be deleted.
2.When clicking in the Y/N-field a POP-UP dialog must
appear asking if the person is sure about the transfer.
3.The "CLIENT" has information related in other tables
which has to be send to other tables in the new database.
How can I do all this without complicated coding, for I
dont know how to type a code?

Thanks
 
Personally, I wouldn't.

I would use flags to indicate if a client was active or not. I would use
that flag in my queries, forms, and reports.

I would not move data between separate databases. In some rare cases (very
rare) I might move a record from one TABLE to another within the same
database, but even that is not normally needed since you can use "type"
fields, or checkboxes to set attributes for the records and then include or
exclude them when working with your data.

Rick B
 
One more note.

You could share the "client" table with many front-end databases. The table
would be linked to the front-ends. Again, the queries, reports, and forms
may only use some of the records in any given front-end.

For example, your "order takers" might use a front-end that allows them to
do their jobs. Your accounting department might use a totally separate
application to do their job. Your CSI people might make followup calls
using a different application. BUT, all of these applications would pull
the customer data from the same shared table living in a back-end on a
server. If the CSI clerk updates a phone number, then the accounting folks
would see that update next time they opened the customer's record.

Hope that helps.

If you need help "linking" the table or structuring the various front-end
and back-end databases, post back with more details.

Rick B
 
Thanks, I think it will make sense. I will flag the clients
and then I will setup the selection for the front-ends
 
Just one more thing, as I have 2 kind of clients: the first
ones with two cathegories within;the second ones with 4
categories within. How would you flag them? Will you use a
YES/NOT check box field? Let me know what methodology fit
the best
 
Back
Top