J
John Calder
Hi
I Run WIn2k with Access 2K
I am a complete novice with this program so I have a few questions.
Senario
I create a table with employee names (called "Names")
I create another table with employees crews (ie: A Crew, B Crew, C Crew etc)
(Called "Crews")
I create a third table with supplimentary data (ie: date, time, part number
etc)
Questions
In the third table do I have to include a column for "Names" data and a
column for "Crews" data?
If I do, then it seems pointless to have a seperate table for these?
If not, where is this information stored? If the case is that it is linked
through relationships then how do I determine the correct relation ship? Do I
just make the ID Autonumber the relationship between each table?
Also, if I enter the names in the "Names" table in a non-alphabetical order,
a combo box in a form reflects this, however if I then go back and sort the
names table the combo box still shows a non alphabetical order, why is this?
or better still how do I get the data in the combo box to reflect the now
sorted data in the "Names" table?
Any help is much appreciated
John
I Run WIn2k with Access 2K
I am a complete novice with this program so I have a few questions.
Senario
I create a table with employee names (called "Names")
I create another table with employees crews (ie: A Crew, B Crew, C Crew etc)
(Called "Crews")
I create a third table with supplimentary data (ie: date, time, part number
etc)
Questions
In the third table do I have to include a column for "Names" data and a
column for "Crews" data?
If I do, then it seems pointless to have a seperate table for these?
If not, where is this information stored? If the case is that it is linked
through relationships then how do I determine the correct relation ship? Do I
just make the ID Autonumber the relationship between each table?
Also, if I enter the names in the "Names" table in a non-alphabetical order,
a combo box in a form reflects this, however if I then go back and sort the
names table the combo box still shows a non alphabetical order, why is this?
or better still how do I get the data in the combo box to reflect the now
sorted data in the "Names" table?
Any help is much appreciated
John