no records on the 'one' side

[Pip''''n]

I am building a database that tracks a dealership's current stock and sales.
Units are added as records to a table called "StockUnits". A "TCA" is created
to negotiate a deal with a customer. An "Appraisal" for a trade in can be
attached to the "TCA". Multiple TCAs can be created for a single stock unit.
From the TCA the salesman can continue with the sale to create a record in
the "UnitSales" table. From here a button is clicked and an invoice number is
generated and the sale is completed.

When I click from the "TCA" to the from for "UnitSales" I receive the error:
"Records in table "TCA" would have no records on the 'one' side" This is an
error that keeps returning and I keep fixing it. Usually the error is
encountered when a new record in the "UnitSales" table is required. Any
suggestions would be greatly appreciated.

 

[John Pritchard]

It sounds like you need to consider the relationship between your UnitSales
and TCA tables. If you look in Access under Tools->Relationships I think
you'll find your tables related - (usually a line with a 1 at one end and
infinity symbol at the other). If you highlight the line and right click you
can edit the relationship. If a detail record (your TCA table I think) should
always have a master (your UnitSales table) then you should enable force
referential integrity, if they arn't related in this way (your post suggests
not) then uncheck the force referential integrity box and the error messages
should stop. A word of warning though - this is really a design question and
if the rest of the system expects the master to exist you may find that
orphan detail records 'disappear' from reports etc as they have no master.
HTH.