Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / December 2005

Tip: Looking for answers? Try searching our database.

Subdatasheets

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mys - 21 Dec 2005 05:27 GMT
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?
tina - 21 Dec 2005 06:57 GMT
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?
Jason S. - 21 Dec 2005 07:31 GMT
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.
Van T. Dinh - 21 Dec 2005 08:58 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.