Alpha Video Training
Results 1 to 8 of 8

Thread: How to add in a second table

  1. #1
    Member
    Real Name
    Wes Olfert
    Join Date
    Jan 2004
    Location
    Tacoma, WA
    Posts
    86

    Default How to add in a second table

    I am trying to build a church database. In the report (or directory) I would like to have a section of Useful Contacts at the beginning before the regular directory, and thought that maybe I could insert it into the header. So far I have not been able to accom;ish this. Any ideas out there? I have attached a directory example to make it easier to understand.

  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: How to add in a second table

    You might be able to accomplish that with the use of

    table.external_record_content_get()

    but it is tedious to work with.

    Should be much easier to have all the records in one table and "classify" them, in a new field for that purpose, as contacts or members, then group the report by the classification.

  3. #3
    "Certified" Alphaholic
    Real Name
    Wanda Tucker
    Join Date
    May 2001
    Location
    Northern California
    Posts
    1,444

    Default RE: How to add in a second table

    Wes,
    Are your "useful contacts" in another table, and you just need to figure out how to link the two tables (because you don't necessarily have an obvious link)?

    Are your "useful contacts" people in the church membership, or community?

    Are your "useful contacts" various business owners who are also members of the church?

    If you can provide a bit more information, I'll brainstorm, some.

    Wanda

  4. #4
    Member
    Real Name
    Wes Olfert
    Join Date
    Jan 2004
    Location
    Tacoma, WA
    Posts
    86

    Default RE: How to add in a second table

    THanks for your looking it over -- Here are the answers inserted after you questions:

    Are your "useful contacts" in another table, and you just need to figure out how to link the two tables (because you don't necessarily have an obvious link)?

    "Useful..." is in another separate table with no linking field.

    Are your "useful contacts" people in the church membership, or community?

    They are not in the church membership or the community -- Just organizataions everywhere and anywhere that are releveant to church work.

    Are your "useful contacts" various business owners who are also members of the church?

    Not members at all -- but usually church related organizations.

    If you can provide a bit more information, I'll brainstorm, some.

    THANKS FOR YOUR THINKING ABOUT THIS. Appreciate your help.

    Wes

  5. #5
    Member
    Real Name
    Wes Olfert
    Join Date
    Jan 2004
    Location
    Tacoma, WA
    Posts
    86

    Default RE: How to add in a second table

    I've thought of combining them into one table but information is so unrelated that I hate to do that. The tables would be much "cleaner" if I keep them separate.

    I'm not sure how to implement your idea of table.external...... but that is something I may work with if some other idea doesn't pop up.

    Wes

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: How to add in a second table

    You would create a calculated field for the report. Its expression would use the mentioned function to extract the useful contacts information from the external table (external to the tabel that the report accesses).

    You then place this calculated field where you like.

  7. #7
    "Certified" Alphaholic
    Real Name
    Wanda Tucker
    Join Date
    May 2001
    Location
    Northern California
    Posts
    1,444

    Default RE: How to add in a second table

    Hi Wes,
    Sorry, I was out ill for a few days...did you find a solution? Please let us know - or if you need help, stll.
    Thanks,
    Wanda

  8. #8
    Member
    Real Name
    Wes Olfert
    Join Date
    Jan 2004
    Location
    Tacoma, WA
    Posts
    86

    Default RE: How to add in a second table

    I have not found a good solution yet. Been learning other things though -- so making progress!!!!

Similar Threads

  1. Parent table based on query of child table.
    By edward.mattison@scbhn.org in forum Alpha Five Version 5
    Replies: 1
    Last Post: 02-25-2005, 04:14 PM
  2. Table.copy_record_to() vs table.record_clone()
    By russ Boehle in forum Alpha Five Version 5
    Replies: 0
    Last Post: 06-28-2003, 04:56 PM
  3. Posting Parent table fields to Child table
    By Jimmie1234 in forum Alpha Five Version 5
    Replies: 1
    Last Post: 09-11-2002, 01:41 PM
  4. Scrolling Screen query table and update table
    By mpierce in forum Alpha Five Version 4
    Replies: 2
    Last Post: 09-21-2000, 09:38 AM
  5. Linking values from table 1 to table 2
    By Tom Sullivan in forum Alpha Five Version 4
    Replies: 8
    Last Post: 04-18-2000, 01:20 PM

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
  •