form display question

[LeonePak]

I have an appointment table that contains time and clients. The table contains "dummy" data so that when form is created from it I get

Time Clients
8pm Time Available
9am Time Available
10am Time Available
11am Time Available

When I make an appointment for a client name John Done for 9am, is there a way for a form to display following ...

Time Clients
8pm Time Available
9am John Doe
10am Time Available
11am Time Available

HyunMi

 

[missinglinq]

In your Design View for your table enter "Time Available" as the default value for each time slot. In your form, when you add a new record (read that New Day) all time slots will read "Time Available". To enter an appointment, simply go to the appropriate time slot and enter the person's name. This name will then appear anytime you go to this day's record.

Hope this helps.

The Missinglinq "It's got to be the going,
not the getting there that's good!"
-Harry Chapin