manufacturing design

[Brian]

My head is about to explode, This shouldn't be as difficult as I am
apparently making this.

I have a small besiness we are setting up with an access database. We
manufacture custom cabinetry so there is not a set "product" although each
product consists of up to several standard components (ie. cabinets, door
units, shelf units, etc).
Currently I am tracking the manufacturing process of these components using
the invoice number as the PK which has a 1:many relationship with the
customer ID. Problem is that occasionally we manufacture models for display
in our showroom and sometimes these display units are sold to customers who
don't want to wait for us to build one. I can't seem to figure out a way to
keep track of the showroom models' production and then associate this
information with a new customer when they buy one "off the shelf"

I have a customer table and an Invoice table. Do I need to set up a seperate
table for the showroom models with an old invoice# and new invoice number
field, or just set up a seperate showroom sales table?

 

[NetworkTrade]

I would simply show yourself as the customer initially. When sold, then type
out that info with the new customer info. Keep it simple.