Multiple field entry from form

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

Guest

I have 3 tables for police reporting
1 is personal information
1 is location of reporting
1 is report information

They feed into 1 form

primary key field is name

I want to know how to display to enter and display numerous reports and date
of report on each indivdual.

I will need to display each report which is around 2-3 lines the field is
memo and is just called reporting

And how can it add a new entry into the table from the form when I need to
enter a new report?

Thank you
 
I have 3 tables for police reporting
1 is personal information
1 is location of reporting
1 is report information

They feed into 1 form

primary key field is name
Click to expand...

That's NOT appropriate for two reasons: names are not unique (I know
three people all named Fred Brown); and it's not appropriate to make
the Name - or even the unique PersonID - the primary key of either
Location or of Report Information, since a report could involve more
than one location, or more than one chunk of report information.

I'd make the primary key of the personal information table a PersonID
(an autonumber if you don't have some other reliable unique identifier
for a person), and put a foreign key field (Long Integer if you use an
autonumber) as a foreign key into the Location and Information tables.
I want to know how to display to enter and display numerous reports and date
of report on each indivdual.
Click to expand...

By getting the tables structured correctly for starts! See above.
I will need to display each report which is around 2-3 lines the field is
memo and is just called reporting
Click to expand...

You can base your mainform on the personal information table, and use
a continuous Subform based on the report information table. Use the
PersonID as the subform's master/child link field. This will show you
all the reports for that person.
And how can it add a new entry into the table from the form when I need to
enter a new report?
Click to expand...

By moving to a new line on the subform, and starting to type.

John W. Vinson[MVP]
 
Back
Top