Viewing multiple records in one form?

M

mightymaggie

I am trying to figure out how to view multiple records in one subform.
I have a frm_Advertiser and a sbfrm_Advertisment. In the subform I
would like to see all advertisement information AND all the issues
(months) in which it runs. Say an ad runs every month- I can't figure
out how to 1) create a new ad record where it runs every month without
duplicating my record 12 times and just changing the month and 2) how
to view it all together after it's entered. Do I have to use a
datasheet? Ideally I would like to see a subform with the ad info and
all the months it's running. The old database did this with checkboxes-
a good visual- but a nightmare when it comes to building the
queries/reports. I don't want my users to ever build their own queries
which is why I'm shooting for parameters. Eventually I'd like to run a
report from a form that feeds my parameters to the report, but first
things first!

Thanks for any help
Maggie
 
T

TedMi

Sounds like you need 3 tables: Advertiser, Ad, RunDate. The latter table
would contain the Ad ID and the date or issue no. when it ran - thus you
could record the multiple running of one ad. The cardinality of your database
would be:
One Advertiser --> many ads; one ad --> many runs.

Although this could be elegantly handled by nested subforms, for simplicity
I recommend displaying the results in non-normal form in a single subform per
Advertiser, with the subform populated by a join query on the Ad - RunDate
tables:
Ad1 Date1
Ad1 Date2
Ad2 Date3
Ad2 Date4
etc.

Displaying multiple records in a subform calls for either a datasheet view
or multiple forms view of the subform.
 
M

mightymaggie

Thanks for your help, Ted.

I have 3 tables right now, set up just the way you recommended. I would
also ad that one run date (month) = many ads. I know the cleanest text
book way to do this is to make each monthly ad it's own individual
record, but regarding data entry, I'm afraid my users will revolt at
having to duplicate it each time (obviously I would automate as much as
possible!) The alternative is making the months part of the Ad table
and not creating a new record for each month. That means checkboxes,
however, and I can't figure out how to run parameter queries off
multiple checkboxes.
 
Top