Form help

  • Thread starter Thread starter George Wilson
  • Start date Start date
G

George Wilson

I have a database with visitor information in one table
and a visit table. For each visit form I would like to be
able to show in a subtable/form all of the visitors
expected. This is similar to the Orders form in the
Northwind database which shows a different list of items
for different order. Does anyone know of any instructions
on the web to accomplish this?
TIA
George
 
Without some reasonable detail, we can't give you specific help... the table
names do not make it obvious what data you have and how the tables are
related. Perhaps if you could clarify with some detail, someone could offer
suggestions.

Does a "Visit" in the "Visit Table" represent an "event" to which multiple
"Visitors" in the "Visitor Information Table" will come? If so, is there a
foreign key in the Visitor Information Table to the Visit table to indicate
which event the visitor will attend, or ???

Is a Visitor limited to just one Visit/event, or can a given Visitor attend
multiple Visits/events? If the latter, the relationship will be more
complex.

Larry Linson
Microsoft Access MVP
 
OK the Visitors table has visitor information. The visits
table has visit information that will have multiple
visitors possibly on multiple occasions. The visit groups
may be small or large depending on the type of visit. I
was hoping to create a form with a sub table that will be
able to list all the visitors associated with each
specific visit date. A visitor is not limited to one visit
and may be on many visits. Each Visit record needs to show
a list of all the visitors on this visit. Hope that is not
too confusing, thank you for your assistance...
George
 
Back
Top