Re: Check in the BoX
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
On Wed, 30 Nov 2005 10:58:37 -0800, "stillLearning"
<stillLearning@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I have a big question. I have a database that has all of our Navy Command
>names and info. I want to be able to input one topic and then be able to
>select who this topic applies too. and then be able to come back later and
>input a new topic and still have the last topic stay with the associated
>name. any information will help.
YOu need THREE tables: Personnel; Topics; TopicAppliesTo.
The latter table will have the PersonnelID (the person's Service
Number I presume) and the Topic as a joint, two-field Primary Key. The
table would be related to Personnel by the PersonnelID, and to Topics
by the topic (or TopicID if you're using a numeric primary key).
If a given person has six topics, they would have six records in this
table.
You'ld use a Form based on the personnel table, with a Subform based
on TopicAppliesTo; on the subform you'ld have a combo box to select
topics.
John W. Vinson[MVP]
.
Relevant Pages
- Re: are reports the primary end files not forms?
... Do you have a personnel table? ... primary key, name, ID number, rank, and other things specific to each person. ... Now you need an education table. ...
(microsoft.public.access.forms) - Re: Social Security Number as a primary key
... Then you'll have a Personnel form which would contain 2 subforms a) ... The recordsource for Personnel would be your ... > these tables together with a primary key, ... I used their social security number as the primary key as well. ...
(microsoft.public.access.forms) - Re: View from a merge of two tables
... they lack a primary key. ... Can I assume that you assign personnel to departments? ... CREATE TABLE CustomerRequests ... Notice that I kick the request to the department level with DRI ...
(comp.databases.ms-sqlserver) - Re: Repeat values in multiple records
... The primary key for a record would be the date, ... with the same date, and same personnel (i'm guessing you mean a person, in ... split the location and item fields into a child table, with a foreign key ... design principles before you do any more work on the database. ...
(microsoft.public.access.forms) - Re: Repeat values in multiple records
... with the same date, and same personnel (i'm guessing you mean a person, in ... split the location and item fields into a child table, with a foreign key ... field linking the records back to the primary key of the date/personnel ... design principles before you do any more work on the database. ...
(microsoft.public.access.forms) |
|
