Alpha Video Training
Results 1 to 3 of 3

Thread: Multiple Databases

  1. #1
    Arthur Casse

    Default Multiple Databases

    I am preparing to set up multiple databases for a user. These databases are basically membership databases with name, address, city, state, zip, etc. One function the user wants is to be able to make an address change to a member no matter which membership database they are in. They want the address change to be made in all databases the member is listed in at one time.

    My question is wether to make one database out of all these memberships or is it possible to keep the databases seperate (since they will have different reports and entry screens) and still have the ability to find the member in each database and make the necessary address change.

    Ideas, suggestions and/or examples are appreciated. Thank you.

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Bowling Green, KY

    Default RE: Multiple Databases

    This sounds like a case for sets. You could have a centralized address table and the separate membership tables. The "person" should have a member id code in each membership table they belong to and a personal identifier code. You would then have a set for each group that the person could be a member of, linking the group information to the address information by the personal code.

    Seems like a place to start, anyway.

  3. #3
    Member Bob Houle's Avatar
    Real Name
    Bob Houle
    Join Date
    Apr 2000
    Vancouver Island, Canada

    Default RE: Multiple Databases

    If you have A5V4 Take a look at the excellent sample called "Mailing List" in the samples sub directory. It uses a central 'people info' table and builds sets from that information.


Similar Threads

  1. new to databases - multiple files at once?
    By Chris Lucas in forum Alpha Five Version 6
    Replies: 3
    Last Post: 09-29-2004, 04:12 AM
  2. multiple databases
    By lkatz1 in forum Alpha Five Version 5
    Replies: 14
    Last Post: 07-02-2004, 09:49 AM
  3. Multiple Databases/Reports
    By Robyne in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-19-2003, 02:14 PM
  4. Multiple Databases with One App and Shadowing
    By Tom Mills in forum Alpha Five Version 5
    Replies: 8
    Last Post: 03-18-2003, 05:43 AM
  5. multiple databases
    By tbrians in forum Alpha Five Version 4
    Replies: 3
    Last Post: 03-02-2001, 10:44 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts