Hi there,
I'm building my first database and think the following design would work but I would like any feedback or advice before I proceed. The purpose of the database is to schedule an installation technician (FSE) and application specialist (APPS) to install equipment at a customer site and train them. An order comes in, which may have been sold by a dealer, it is assigned to a technician and an application specialist and a separate appointment needs to be made for each. Ultimately, this will be viewed as a calender as a form.
Many thanks in advance!