Need Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
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
 
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
.....
 
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
 
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.
 
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.
 
Back
Top