Greetings,

> Is there a standard in field naming?
>
> Assume you've a table APPOINTMENTS:
>
> Is the standard:
>
> APPOINTMENTID
> CENTREID
> EQUIPMENTID
> APPOINTMENT
>
> or:
>
> APP_APPOINTMENTID
> APP_CENTREID
> APP_EQUIPMENTID
> APP_APPOINTMENT
>
> And then table CENTRES:
>
> CENTREID
> NAME
>
> or
>
> CENTRE_ID
> CENTRE_NAME
>
> Thus, using a prefix or not?

There are no standards yet. At least that I know of...

Using a Prefix just make field names longer. When you reference them later
you will use this syntax:

qryAppointmentsAppointment_ID.AsInteger or
qryAppointments.FieldByName('Appointment_ID').AsInteger

Also place an underscore between your field names as in:

APPOINTMENT_ID
CENTRE_ID
EQUIPMENT_ID
APPOINTMENT

Just my 2 cents on how I've been doing it.

Mike