Programming "next appoinment" on to invoice form

[Guest]

I have created a program that schedules and invoices clients for services
rendered. I would like to program an additional bit of information onto the
form, but am foggy as to how to go about it.

Often, clients will book appointments in the future, and I would like to add
a "Next Appointment is" date field.

I could see creating a box on the form which would attach to my appointment
table. By using SQL logic I could compare the dates for a customer to today's
date and have it return the next value in the list. Is this the most
efficient way of pulling the next date? Are there any pitfalls to this
approach (e.g., if a person has multiple future appointments)?

 

[Marshall Barton]

I have created a program that schedules and invoices clients for services
rendered. I would like to program an additional bit of information onto the
form, but am foggy as to how to go about it.

Often, clients will book appointments in the future, and I would like to add
a "Next Appointment is" date field.

I could see creating a box on the form which would attach to my appointment
table. By using SQL logic I could compare the dates for a customer to today's
date and have it return the next value in the list. Is this the most
efficient way of pulling the next date? Are there any pitfalls to this
approach (e.g., if a person has multiple future appointments)?

If the client's next appointment is already entered in the
Appointments table, this I think the simplest way to display
the date on the form is to use a text box expression like:

=DMin("appdate", "Appointments", "ClientID=" & ClientID)

If you want to create the apponitment from your text box,
you'll need to explain more about the tables, their fields
and how you want things to behave before I could make a
meanungful suggestion. However, I do suggest that you have
an appointments form for this purpose.