I was thinking of using three tables:
tblCustomer
CustomerID (PK)
CustomerName
tblOrder
OrderID (PK)
CustomerID
tblRepair
RepairID (PK)
OrderID
Orders would always be associated with a customer, and repairs would always
be associated with an order. You would not necessarily always have a repair
associated with an order, but you could have several repairs associated with
an order. That is why I mentioned a note field, where you could state that
an order is simply a repair, which is not associated with your work on a
previous order.
This is, of course, just a bare bones of the tables, because you would also
have fields to detail supplies used, finished sizes, etc. Supplies could
even be in a fourth table, as frameworks, mattings, different types of glass.
It is possible to get a little carried away with the details that can be
compiled in various tables. For instance, you could have tables that just
detail the different frameworks that can be used. Or, you can have a table
with all the different supplies, but with a field that specifies the type of
supply that it is.
You could have a field in your orders table that will just be for detailing
the type of framework, then have two more fields that will be the height and
width of that framework. Or have a separate table that draws from a
materials table and the orders table to detail what you are using in an
order. Or you can just have a large memo field where all of that is typed
in. That is the really tough part about setting up a database, is deciding
what you really want and need as fields.
Another consideration is what you will do with all of this information. If
you only need to know the specifics of an order while you are filling the
order, then a large memo field for the description is probably all you need.
If you want to do statistical analysis or materials tracking, then you may
need to make fields a little more specific for tracking that sort of
information.
Taking a little time now to consider such things will make your database
much more useful for what you need it for. It might also cause you to
consider purchasing a "canned" program for doing some of this (or download a
template).
Good luck with your project.