M
Medoomi
Hi,
I'm a bit lost, and finding the Access learning curve *very* steep...
Anyway, I have read about using filtered queries to limit available
selections in eg. combo box 2 based on the entry selected from combo
box 1. However, I think I need something a little different.
I am trying to develop a database to catalogue "talks" given at
various locations (locations are three lookup tables: Country, Region,
and Building). And the main reason I do not wish to use filtered
queries is that I wish the locations to be unique (eg. two different
regions might have a building with the same name, but these locations
are unique).
So far, I have the following table for the talks
tblTalks
TalksID (PK Autonumber)
Talks
And I have the following structure for drilling down to a unique
location:
tblLocations
LocationID (PK Autonumber)
CountryID (FK)
RegionID (FK)
BuildingID (FK)
tluCountries
CountryID (PK autonumber)
Country
tluRegions
RegionID (PK autonumber)
Region
CountryID (FK)
tluBuildings
BuildingID (PK autonumber)
BuildingName
RegionID (FK)
But I would not have a clue how to relate the talks to the locations.
My only stab was to relate tbltalks to tblLocations through another
table containing
TalksID (FK)
LocationID (FK)
in order to create a many-to-many relationship--for on talk can be
given at many locations, and one location can receive many talks)
At the moment I don't know the next step.
Can someone please enlighten my befuddled mind.
Thx
I'm a bit lost, and finding the Access learning curve *very* steep...
Anyway, I have read about using filtered queries to limit available
selections in eg. combo box 2 based on the entry selected from combo
box 1. However, I think I need something a little different.
I am trying to develop a database to catalogue "talks" given at
various locations (locations are three lookup tables: Country, Region,
and Building). And the main reason I do not wish to use filtered
queries is that I wish the locations to be unique (eg. two different
regions might have a building with the same name, but these locations
are unique).
So far, I have the following table for the talks
tblTalks
TalksID (PK Autonumber)
Talks
And I have the following structure for drilling down to a unique
location:
tblLocations
LocationID (PK Autonumber)
CountryID (FK)
RegionID (FK)
BuildingID (FK)
tluCountries
CountryID (PK autonumber)
Country
tluRegions
RegionID (PK autonumber)
Region
CountryID (FK)
tluBuildings
BuildingID (PK autonumber)
BuildingName
RegionID (FK)
But I would not have a clue how to relate the talks to the locations.
My only stab was to relate tbltalks to tblLocations through another
table containing
TalksID (FK)
LocationID (FK)
in order to create a many-to-many relationship--for on talk can be
given at many locations, and one location can receive many talks)
At the moment I don't know the next step.
Can someone please enlighten my befuddled mind.
Thx