If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Plus sign on datasheet forms not showing
Dear All,
Just a hope that somebody may know the answer to this off the top of their head... I've got an Access 2000 database for a customer based on a SQL Server 2000 backend. There are three tables: Event, VenueGroup and Venue linked together as follows: * Event linked to VenueGroup as a One to many by EventId (int with a sequence to generate the next number automatically) * VenueGroup linked to Venue as a one to many by VenueGroupId (int with a sequence to generate the next number automatically) so an event record can have a number of VenueGroup records which in turn contain a number of venue records. The purpose of this system is to create an overall event item with smaller venues belonging to it. The smaller venues are grouped together under VenueGroup which contains resources common to venue records. I have a single form to show Event records, this has a number of tabbed pages on it, one of which has a datasheet form to display VenueGroup records The VenueGroup datasheet form in turn has a datasheet on it to display Venue Records. When I open my VenueGroup datasheet form outside of the event form, it displays a plus sign to show that venue records are available under the VenueGroup If I put the VenueGroup datasheet on the event form without linking it by eventid it still shows the plus sign If I link the VenueGroup datasheet to the event form by eventid then the plus sign won't show, even if venue records exist. This seems to happen whether I use Parent/Child Linked fields, or incorporate a link in the VenueGroup forms datasource What am I missing?? Thanks in advance! Paul Le Sueur. |
Thread Tools | |
Display Modes | |
|
|