Breadcrumbs in a form?

[The Boondock Saint]

Howdy All
Can you have a breadcrumbs style display of information in a form?

I have a table of data which has

ID
PARENT ID
NAME

Anything with a Parent ID of 0 is in the main category
What I would like to be able to show is where that record is in the
structure of things...

Lets say this is some data

ID - PARENT ID - NAME
1 - 0 - Cars
2 - 0 - Trucks
3 - 0 - Motorbikes
4 - 2 - Big Rigs
5 - 4 - 18 Wheelers

Is there a way so that when im on the record for ID 5 it could show....

MAIN >> TRUCKS >> BIG RIGS >> 18 Wheelers

Any ideas? Access 2003

 

[Guest]

Hi

You could create an unbound text box and use this as the record source
=[ID]&">>>"&" "&[PARENT ID]&" "&">>>"&[ NAME]

This would give the same results but ensure you put the spaces in the same
(there is a space after each >>> as thats what I think you have in your
sample??)
=[ID]&">>> "&[PARENT ID]&">>> "&[ NAME]


hope this helps

 

[The Boondock Saint]

Thanks wayne,

Wouldnt that give me the ID number, and not the name of the parent category?

Cheers for the help....

Hi

You could create an unbound text box and use this as the record source
=[ID]&">>>"&" "&[PARENT ID]&" "&">>>"&[ NAME]

This would give the same results but ensure you put the spaces in the same
(there is a space after each >>> as thats what I think you have in your
sample??)
=[ID]&">>> "&[PARENT ID]&">>> "&[ NAME]


hope this helps

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

Howdy All
Can you have a breadcrumbs style display of information in a form?

I have a table of data which has

ID
PARENT ID
NAME

Anything with a Parent ID of 0 is in the main category
What I would like to be able to show is where that record is in the
structure of things...

Lets say this is some data

ID - PARENT ID - NAME
1 - 0 - Cars
2 - 0 - Trucks
3 - 0 - Motorbikes
4 - 2 - Big Rigs
5 - 4 - 18 Wheelers

Is there a way so that when im on the record for ID 5 it could show....

MAIN >> TRUCKS >> BIG RIGS >> 18 Wheelers

Any ideas? Access 2003

 

[Guest]

Hi Just tried this out (soory bit of aircode firsttime)

It does work. You need to have the fields in the form somewhere for it to
work (set the visible to No if you don't want to see them).

Or - maybe I'm not fully understanding what you're trying to do and from
where the data will come from. Sorry if this is the case.



--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

Thanks wayne,

Wouldnt that give me the ID number, and not the name of the parent category?

Cheers for the help....

Hi

You could create an unbound text box and use this as the record source
=[ID]&">>>"&" "&[PARENT ID]&" "&">>>"&[ NAME]

This would give the same results but ensure you put the spaces in the same
(there is a space after each >>> as thats what I think you have in your
sample??)
=[ID]&">>> "&[PARENT ID]&">>> "&[ NAME]


hope this helps

--
Wayne
Manchester, England.
Not an expert
Enjoy whatever it is you do

Howdy All
Can you have a breadcrumbs style display of information in a form?

I have a table of data which has

ID
PARENT ID
NAME

Anything with a Parent ID of 0 is in the main category
What I would like to be able to show is where that record is in the
structure of things...

Lets say this is some data

ID - PARENT ID - NAME
1 - 0 - Cars
2 - 0 - Trucks
3 - 0 - Motorbikes
4 - 2 - Big Rigs
5 - 4 - 18 Wheelers

Is there a way so that when im on the record for ID 5 it could show....

MAIN >> TRUCKS >> BIG RIGS >> 18 Wheelers

Any ideas? Access 2003