S
scoutingfish
I'm building a database for a business directory, and I'm trying to
get the printed copy to be generated by a report. The way the database
is structured right now, each listing has a category that it sits in,
a description, a title, and an address. But... each listing also can
have more than one phone number or link, as some businesses have more
than one phone number, and some have more than one web or email
address. The links are stored in a separate table, and each entry is
bound to a record in the listings table using a many-to-one
relationship. The same is done with the phone numbers.
I was able to create a form for entering data, and it was able to work
with the two subforms on the same level.
The data structure needs to look like this:
Listing
Address
Category
Description
Link
Link
...
Phone
Phone
...
And I need it to display like this:
Category
Listing
Address
Phone (once for each record related to the current listing)
Link (once for each record related to the current listing)
Description
Listing
...
I'm not sure if I'm even going about this the right way. I'm starting
to think that I might need to merge into a word document, but I don't
know if there's any way to get it to work this way. I've done stuff
kinda like this with SQL and XML via XSLT. And I've done rosters in
Access that display kids as a subset of the parents, but I haven't
done even that in a while, and I can't remember how I did it for the
life of me. I really don't know if that would even help anyway.
If anyone has any idea or inkling on how I might do this, it would be
much appreciated
Thanks muchly
get the printed copy to be generated by a report. The way the database
is structured right now, each listing has a category that it sits in,
a description, a title, and an address. But... each listing also can
have more than one phone number or link, as some businesses have more
than one phone number, and some have more than one web or email
address. The links are stored in a separate table, and each entry is
bound to a record in the listings table using a many-to-one
relationship. The same is done with the phone numbers.
I was able to create a form for entering data, and it was able to work
with the two subforms on the same level.
The data structure needs to look like this:
Listing
Address
Category
Description
Link
Link
...
Phone
Phone
...
And I need it to display like this:
Category
Listing
Address
Phone (once for each record related to the current listing)
Link (once for each record related to the current listing)
Description
Listing
...
I'm not sure if I'm even going about this the right way. I'm starting
to think that I might need to merge into a word document, but I don't
know if there's any way to get it to work this way. I've done stuff
kinda like this with SQL and XML via XSLT. And I've done rosters in
Access that display kids as a subset of the parents, but I haven't
done even that in a while, and I can't remember how I did it for the
life of me. I really don't know if that would even help anyway.
If anyone has any idea or inkling on how I might do this, it would be
much appreciated
Thanks muchly