Alpha Video Training
Results 1 to 3 of 3

Thread: Multiple Databases

  1. #1
    Arthur Casse
    Guest

    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
    Location
    Bowling Green, KY
    Posts
    25,119

    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
    Location
    Vancouver Island, Canada
    Posts
    332

    Default RE: Multiple Databases

    Arthur,
    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.

    --Bob

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

Bookmarks

Posting Permissions

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