You need tables similar to these:
TblParts
PartID
PartDesc
Cost
etc
TblServiceRecord
ServiceRecordID
Customer
CustomerAddress
DateOfService
ServicePerformedBy
etc
TblServiceDetails
ServiceDetailsID
ServiceRecordID
PartID
QtyOfPart
Cost
Discount
Build a main form based on TblServiceRecord and a subform based on
TblServiceDetails.
If you need help setting up your database, contact me at my email address
below.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com www.pcdatasheet.com
"noname" <no*************@nospam.net> wrote in message
news:S%*****************@fe03.lga...
I have no clue where to start.
Do I have another table of parts?