two-tier database app with lookup

[RogerR]

Hello

I am looking for a two-tier database (eg alphabet, words beginning with each letter), plus look up function, (eg if the word is a noun or verb).

any help would be appreciated

[Marc_Dillon]

I think you need to elaborate.

[RogerR]

ok. i want to list the full alphabet, clicking on each letter opens sub list of words beginning with that letter, then clicking on the selected word to if it is a verb or noun.

Eg C, completetion, noun

[dbaum]

Here's a basic approach to start with and experiment. Create a table with the following columns:

1. Word
2. First Letter (this column could use an app formula like LEFT([Word], 1))
3. Part of Speech

Create a view with the Group by property configured to group rows first by [First Letter] and then by [Word].

[RogerR]

Will give that a try, thx for the suggestion