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

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

Answer 1

User-1716253493 posted

Add column manualy, set HeaderText as what you want.

Answer 2

User442781244 posted

how do I set the structure inside msaccess?

Answer 3

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

30,0

32,1

33, 2

and in web app:

select * from menu order by pmenu,sort

Answer 4

User-1716253493 posted

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

TableA : ID, Title

TableB : ID, Title, TableAID

Answer 5

User-2007877324 posted

It seems you need to show a hierarchy of menus. Check these links

Using a Query to Show the Relationship Between Employees and Supervisor

Logic for displaying infinite category tree in nested <ul>s from Self Join Table

Simplest way to do a recursive self-join in SQL Server?

 

 

Answer 6

User442781244 posted

oned_gk

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???

Answer 7

User-2007877324 posted

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

LetterID

LetterCaption

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

 

Answer 8

User442781244 posted

http://social.msdn.microsoft.com/Forums/en-US/46a5b2c6-c5c0-480d-8c11-45ea2ff12c86/how-to-change-caption-column-structure-in-ms-acess-dbcaption-is-column-in-ms-acess-db

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.

Answer 9

User-1716253493 posted
First populate parent menu items, then based parents id value populate child items filtered by parent id.

Answer 10

User442781244 posted

could u plz explain???

Answer 11

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.

Answer 12

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?