Results 1 to 6 of 6
  1. #1
    Member
    Join Date
    January 18th, 2005
    Posts
    184
    I have a database with city names and I'm pulling them up by country.

    So the country index page lists the city names for tourist attractions

    Like France: Paris, Provence, etc. But there are multiple records for Paris for example.

    So my city page might look like:
    paris
    provence
    paris
    paris
    paris


    Any ideas how to make WM-RECORD only pull unique names? Thanks.

  2. #2
    Full Member
    Join Date
    January 18th, 2005
    Posts
    291
    I've learned that I must sort categories, maybe even subcategories and so on depending what I may call for a list to make sure I don't get dupes.

    If they're all grouped together I get one each, if there's any seperation in when a record is named by category, I'll get dupes.

  3. #3
    The Eternal Optimist zimmy's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    696
    There is an easy way - use the IndexLabel tag inside your record tag.

    [WM-IndexLabel: city(or however your category for Paris reads)]

    [/WM-IndexLabel]



    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

    The big shots are only the little shots who keep shooting.
    -Christopher Morley

  4. #4
    Member
    Join Date
    January 18th, 2005
    Posts
    60
    Using this same example... I am stumped at how to do this (stops me from buying the full version). But othewise I am VERY happy with how it can format vs just using Access macros and templates.

    Since France can have hundreds of cities starting with P for example only....

    How to create an index page in a 3/4 level setup so the index would be the first letter of the city name - I guess what I want is an index page of just the 1st letter of every city in France or 0 to 9 and A to Z that points to the next level down (why ... because there might be 1000 cities with the letter P alone )... for example

    France ---- click to next level index of cities
    P or any other letter --- next level to city names
    Paris or Province --- click to detail page

    I thought I saw a way to do it in the tutorial, but when I tried it did not work for me.

  5. #5
    The Eternal Optimist zimmy's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    696
    You could use your spreadsheet and make a new column. For each city that starts with a P put P in that column. Then set it up on Webmerge to use that information first, then connect that to the actual city names.

    The tutorial that Frank wrote will work with what you are trying to do - sometimes it takes doing it a few times to really understand how it works. Once it clicks, then you will be able to see all the cool things you can do. Webmerge is an awesome tool!



    ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*

    The big shots are only the little shots who keep shooting.
    -Christopher Morley

  6. #6
    Member
    Join Date
    January 18th, 2005
    Posts
    60
    Zimmy,

    Great idea, I will have to try it.

  7. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. SAS ProductID - not unique? How to identify unique record?
    By markwelch in forum Programming / Datafeeds / Tools
    Replies: 26
    Last Post: June 27th, 2008, 06:41 PM
  2. Unique category name
    By greentea in forum Programming / Datafeeds / Tools
    Replies: 4
    Last Post: April 2nd, 2004, 12:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •