I am trying to add a service history per each customer's vehicle. When I
added a record on one of the subdatasheet it copies to all the subdatasheets.
Help! How do I avoid this?
first, i wouldn't use a subdatasheet in a table. for more information, see
http://allenbrowne.com/bug-09.html and scroll down to Tables:
SubdatasheetName. normally, you use a mainform/subform setup to handle data
entry into a parent table and its' related child table.
sounds like the relationship between the vehicle table and the service
history table is not correctly set up. you probably have (or probably should
have) the following tables, as
tblCustomers
CustID (primary key)
FirstName
LastName
(other fields that describe a customer)
tblCustomerVehicles
VehicleID (primary key)
VehicleYear
VehicleMake
VehicleModel
CustomerID (foreign key from tblCustomers)
tblVehicleServiceHistory
HistoryID (primary key)
VehicleID (foreign key from tblCustomerVehicles)
ServiceDate
(other fields that describe a specific instance of service for a specific
vehicle)
the relationships are
tblCustomers.CustomerID 1:n tblCustomerVehicles.CustomerID
tblCustomerVehicles.VehicleID 1:n tblVehicleServiceHistory.VehicleID
the proper table structure and relationships are necessary for records to be
stored and related correctly, so check your design to see if it matches the
above example. post back with further questions, more detail, etc, as
needed.
hth
> I am trying to add a service history per each customer's vehicle. When I
> added a record on one of the subdatasheet it copies to all the subdatasheets.
> Help! How do I avoid this?
mys - 21 Dec 2005 15:01 GMT
Thanks,, will let youknow how it goes,,
> first, i wouldn't use a subdatasheet in a table. for more information, see
> http://allenbrowne.com/bug-09.html and scroll down to Tables:
[quoted text clipped - 40 lines]
> subdatasheets.
> > Help! How do I avoid this?
This problem might be: you are using an update query. Hope this was a useful
response. I believe you've used the word subdatasheet improperly in this
posting [I've been wrong :) Another possibility is that you're using a
faulty relationship structure.
mys - 21 Dec 2005 16:00 GMT
Hi Thanks for the reply..I don't understand what's an update query.. sorry
i'm really new.. I have a table for my contacts and want to make a subdata
for wach customer containing their car service history. Everytime I add a
data in that subsheet it copies to all other customers sub sheet.
> This problem might be: you are using an update query. Hope this was a useful
> response. I believe you've used the word subdatasheet improperly in this
> posting [I've been wrong :) Another possibility is that you're using a
> faulty relationship structure.
Have you set the LinkMasterFields and LinkChildFields for the Sub-Datasheet?
OTOH, proper interface for data entry is Form / Subform combination and
users should NOT enter data directly in the DatasheetView of the Parent
Table / Child Table.

Signature
HTH
Van T. Dinh
MVP (Access)
>I am trying to add a service history per each customer's vehicle. When I
> added a record on one of the subdatasheet it copies to all the
> subdatasheets.
> Help! How do I avoid this?
mys - 21 Dec 2005 16:02 GMT
You mean I should not enter manually data in the subsheet? I'll try the forms
and subform.. hmmm.. I am so new in this but I hope I'll be successful.
Thanks!
> Have you set the LinkMasterFields and LinkChildFields for the Sub-Datasheet?
>
[quoted text clipped - 6 lines]
> > subdatasheets.
> > Help! How do I avoid this?
Van T. Dinh - 21 Dec 2005 22:27 GMT
I am sure there is a Form Wizard that can create the Form / Subform
combination for you.

Signature
HTH
Van T. Dinh
MVP (Access)
> You mean I should not enter manually data in the subsheet? I'll try the
> forms
[quoted text clipped - 12 lines]
>> > subdatasheets.
>> > Help! How do I avoid this?