how to change caption column structure in Ms acess db..........caption is column in Ms acess db RRS feed

  • Question

  • User442781244 posted

    HI masters, i have an website whose caption is coming from Ms acess db. structure is like this

    letter receipt

    new letter receipt

    letter dispatch

    i want this structure

    1>letter receipt ----a>new letter receipt

                                    b> dispatch

    how to do  it . plz see screen shot and suggest

    Wednesday, September 25, 2013 1:47 AM

All replies

  • User-1716253493 posted

    Add column manualy, set HeaderText as what you want.

    Wednesday, September 25, 2013 2:34 AM
  • User442781244 posted

    how do I set the structure inside msaccess?

    Wednesday, September 25, 2013 3:02 AM
  • User442781244 posted

    i got this idea from on net....any idea how to do this....correct or not???...plz suggest

    Add column sort and use for enforce menu order in web app...

    axample values 

    id, sort



    33, 2

    and in web app:

    select * from menu order by pmenu,sort

    Wednesday, September 25, 2013 5:04 AM
  • User-1716253493 posted

    Im not realy get your requirement, if im not wrong understanding. Maybe like this

    TableA : ID, Title

    TableB : ID, Title, TableAID

    Thursday, September 26, 2013 8:30 PM
  • User442781244 posted


    just leave this idea.

    ..just tell me in ms acess I have  1 column named as caption  and that column  has 1 box  in which letter receipt is written......in that box i want to create tree structure,

    now u understood wht i want to do???

    Friday, September 27, 2013 11:54 AM
  • User-2007877324 posted

    You need a parent child hierarchy. For that your table structure should be



    ParentID  (self join to the Letter ID)


    Then in your view, along with showing a textbox, show a dropdown of the previously entered letter receipt so that the parent is picked. By doing this you will get the hierarchy.

    Check this link for more information

    Presenting a Parent/Child Relationship with MVC 3


    Friday, September 27, 2013 12:10 PM
  • User442781244 posted


    kindly see this link....here is screen shot...see cpation column and below caption column =u will see letter receipt in that box i have to create tree structure...hope diagram will give better idea.

    Saturday, September 28, 2013 12:40 AM
  • User-1716253493 posted
    First populate parent menu items, then based parents id value populate child items filtered by parent id.
    Saturday, September 28, 2013 12:48 AM
  • User442781244 posted

    could u plz explain???

    Monday, September 30, 2013 11:49 AM
  • User-2007877324 posted

    You requirement is not clear. Please elaborate more on what to achieve and what you have done so far. Also post your code.

    Monday, September 30, 2013 12:01 PM
  • User-2007877324 posted

    I think I understood your question. In order to correctly answer please provide the following details:

    • How are you reading the data from the access db (selecting data)
    • How are representing this data to user.
    • Is this used for sitemap?


    Monday, September 30, 2013 8:35 PM