Alpha Video Training
Results 1 to 3 of 3

Thread: Database Design Guidance

  1. #1
    Member Graham Wickens's Avatar
    Real Name
    Graham Wickens
    Join Date
    Apr 2000
    Location
    Gloucestershire, UK
    Posts
    795

    Default Database Design Guidance

    At the moment I have one Table with all active & closed airfields as well as non-airfield sites like Museums, scrapyards, displayed etc.
    Is it possible to split the airfield sites from the non-airfield site into two tables, BUT still be able to do a lookup on both [ie the datum from either goes into the same field on the master table]? If so, how do I do it?

    thanks
    --
    Support your local Search and Rescue Unit, Get Lost!

    www.westrowops.co.uk

  2. #2
    "Certified" Alphaholic
    Real Name
    jim chapman
    Join Date
    Apr 2000
    Posts
    1,779

    Default

    Quote Originally Posted by Graham Wickens
    .............Is it possible to split the airfield sites from the non-airfield site into two tables, BUT still be able to do a lookup on both [ie the datum from either goes into the same field on the master table]? If so, how do I do it? thanks
    Yes, as long as there is some kind of indication in the table. Take a look at conditional table lookups in the field rules. If there is no way of automatically knowing which table should be looked up, then a routine would have to be built where the user would indicate which table to lookup to.

    Good luck,
    Jim

  3. #3
    "Certified" Alphaholic
    Real Name
    Ohlen Cartmell
    Join Date
    Apr 2000
    Posts
    1,599

    Default

    Quote Originally Posted by Graham Wickens
    Is it possible to split the airfield sites from the non-airfield site into two tables, BUT still be able to do a lookup on both [ie the datum from either goes into the same field on the master table]? If so, how do I do it?
    Not to be critical, but why would you want to do this. Alpha can store it all in one table and queries, filetered indexes, etc can be used to separate the entries for reports. It's easier to divide data than it is to put it back together.

Similar Threads

  1. Modular Database Design Question
    By Peter.Wayne in forum Alpha Five Version 5
    Replies: 9
    Last Post: 09-07-2003, 08:29 PM
  2. Database design question
    By Ronald Anusiewicz in forum Alpha Five Version 5
    Replies: 10
    Last Post: 09-02-2003, 02:04 PM
  3. Database design progressive update
    By Chris Teo in forum Alpha Five Version 5
    Replies: 2
    Last Post: 08-07-2002, 06:57 PM
  4. Database Design Questions...
    By John Dodson in forum Alpha Five Version 4
    Replies: 8
    Last Post: 02-26-2002, 02:19 PM
  5. Designers: Front end for database design
    By tlyon in forum Alpha Five Version 4
    Replies: 5
    Last Post: 06-11-2001, 12:08 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
  •