G
gavin
As long as I only have one table to work with I can normally find my way
around the basics of Access fairly well - the Help menu being my best friend
However, I am working on a database with more than one table and I can't get
my head round it - could someone please offer some advice. I know it's not a
difficult scenario but I can't work it out.
The database is to record information about visits to various venues which
need to be inspected. What I have done so far is to create two tables - one
for the venues (including fields for name of venue, street city, post code,
telephone, email address etc) and one for the visits (fields for who made
the visit, date of visit, reason for visit, action taken etc). I created a
form and subform using the Wizard with the venue table as the main form and
the visits table as the subform - but I'm not sure I've got that the right
way round?
So far there are only 9 venues (this will grow to about 15, 20 max). What I
would like to be able to do is to select the name of the venue from a drop
down box and have the fields associated with that venue populate the
relevant fields in the form. I can't figure this out.
I would be very grateful if someone could give me some pointers here - be
brutally honest, I know I'm screwing it up!
Gavin
around the basics of Access fairly well - the Help menu being my best friend
However, I am working on a database with more than one table and I can't get
my head round it - could someone please offer some advice. I know it's not a
difficult scenario but I can't work it out.
The database is to record information about visits to various venues which
need to be inspected. What I have done so far is to create two tables - one
for the venues (including fields for name of venue, street city, post code,
telephone, email address etc) and one for the visits (fields for who made
the visit, date of visit, reason for visit, action taken etc). I created a
form and subform using the Wizard with the venue table as the main form and
the visits table as the subform - but I'm not sure I've got that the right
way round?
So far there are only 9 venues (this will grow to about 15, 20 max). What I
would like to be able to do is to select the name of the venue from a drop
down box and have the fields associated with that venue populate the
relevant fields in the form. I can't figure this out.
I would be very grateful if someone could give me some pointers here - be
brutally honest, I know I'm screwing it up!
Gavin