Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Massachusetts, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date/Time Lookup (2002 (XP))

    I have a Table with a list of times in. I need to perform a lookup of these times in another table but it says I can't when I use the lookup wizard. Is there anyway around this?

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date/Time Lookup (2002 (XP))

    On your form have the user select the time via a combo which is based on this other table.

    BTW duplicating field contents in different tables is not recommended, a relational link is generally better so the data stays in sync with any changes.

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Massachusetts, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date/Time Lookup (2002 (XP))

    If I create a relationship in the relationship window and enforce updates,
    deletes, and integrity after I make the lookup will that keep the data in
    sync?

    what I'm doing is creating an appointment database. Appointments are at set
    times(every 20 mins including the top of an hour) so I have a list (table)
    of all the appiontment times. I was going to create a schedule table where I
    would select a provider, a date, and then times that they will take
    appointments. The final step will be to add people to a field in this record
    thereby making an appointment. (ie fields = provider-day-time-patient) this
    would be a linking table between the provider table and the patient table.

    Let me know if this seems sound.

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date/Time Lookup (2002 (XP))

    If appointments are always at 20 minute intervals do you need a table to store this information in?

    An alternative is for your provider to have a range from..till and use this to populate a combo with the possible appointment times for the given day for that provider.

    There are questions you probably have to adress - a booking taking more than one appointment slot, double bookings in a slot, I feel your structure here may not be satisfactory.

Posting Permissions

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