This is my first
post so be gentle.
I am trying to
display all records from one table with matching records from another. I
joined the table and get all matching records. What I have works except
that it repeats the information from the first table for each record in the
second. Something like this:
Vendor:
10X
Item:
123
Vendor
10X
Item:
124
Vendor
Remington
Item:
870
Vendor
Remington
Item: 870
Express
....
would Like to get
something like this
Vendor
10X
Items:
123
Items:
124
Vendor
Remington
Item:
870
Item: 870
Express
I have another page
that pulls just one record form the Vendor Table and all the Items for that
vendor to view one record at a time. Which is one path that
works.
Here is the page -
again be gentle - I am going to use cfdocument and output to PDF, and I did try
to limit the records with the function in the Repeatable region wizard
but it did not work so it will take some time to
load.
I would appreciate
any help.
Thank
you,
Mike Sumner
Nations Best Sports
817-788-0034 ext 244
817-788-8542 Fax
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
