Need Help

[teelee]

Is there anyway to set up a form using Name, Age, DOB, Race, Hair Color, Eye
Color, Sex more then one time? For example I have Suspect/Hostage
Description. There can be more than one Suspect/Hostage.

 

[Duane Hookom]

That's pretty much what almost every Access application does.

 

[teelee]

What do you mean by that? Can I use the Age, Race, Sex, Eyes, Hair for all?
In other words there are more then one hostage/Suspect.

 

[J. Goddard]

You'll have to give us more details on what you are trying to do. If
you have all those fields in a table, and a form that has that table as
a record source, then the form can add as many records to the table as
you like.

John

 

[teelee]

Ok for example: I have 3 different Suspect/hostage Descriptions, what they
are asking for is name, age, dob, ht, wt, eye color, hair color. How would I
set this up in my form? Or would it be easier to use a tab control? There
will be sometimes more than one suspect/hostage so I have to give answers.

Thanks

 

[Duane Hookom]

I think you need to forget about forms and tabs. Focus on getting your table
structure correct. Forms and reports are built after a good table design is
created. I expect you need tables like:

tblIncidents
=================
IncidentID
IncidentDate
....

tblInvolved
==================
InvolvedID
IncidentID
InvolvementType (suspect, hostage,...)
FirstName
LastName
DOB
InvolvedHeight
HairColor
.....

 

[J. Goddard]

Ok, from what you describe, I'm guessing you can have multiple
suspect/hostages for any given "incident". If this is the case, this is
a situation where you could use a form and subform. The main form for
the incident, with the subform for the suspects/hostages. The subform
could add as many records as you need.

Is this close?

John

 

[teelee]

yes this is close, but how would i set up the subform?

Thanks

 

[Duane Hookom]

This would be set up the same as the order details subform in the Northwind
mdb. In Northwind, an order can have any number of details/products. You
have an Incident that can have any number of suspects/hostages.

 

[teelee]

How do I get Northwind, I don't have it.


Thanks

 

[Duane Hookom]

Northwind should have been installed with Access as a sample application. I
was just referencing it because it showed how to use a subform to display
"child" records.