Creating a system

[Karolak]

I have solved the problem my self now I have different one can anyone help me to create form like this

• Make an appointment form
• Display a list of owners
• Display a list of animals belonging to a selected owner


• Display the animal ID in text field
• Display and select a vet for the appointment
• Display the vet ID in text field
• Write the appointment type
• Select a date and time for the appointment
Confirm the appointment and update the database.
Then create button that will print the appointment card. Thank you for your help.

[June7]

Why are you using INSERT sql to create records?

This is basic Access functionality. Access Help has guidelines.

Build a form and bind it to the Appointments table.

Use comboboxes to display 'lists' and select entities.

Use dependent (cascading) comboboxes to restrict choices. http://www.datapigtechnologies.com/f...combobox2.html