New to Access world

[tigwebu]

Hi. I am new to the whole world of access. I am building a form based on a table that is set up with the following header; id, base, percent and effective date. My primary key is id and effective date. I would like to create a form, that would stack my base, percent and effective date in descending order. Example of table is;
Table
id base percent effective date
x1 5 .15 8/1/2012
x1 3.2 .10 4/1/2012
x1 2.8 .05 4/1/2011
x2 6 .08 8/1/2012
x2 5.3 .10 4/1/2011
x2 2.8 .24 4/1/2010
FORM


id: x1
BasePercent Effective date
5 .15 8/1/2012
3.2 .10 4/1/2012
2.8 .05 4/1/2011

Secondly, is it possible to have a mutliple tier drop-down box similiar to excel.
Ex; First dropdown would have a, d and g. If a. is selected than the second drop down would only display b and c. If d. is selected in first dropdown than second dropdown would only display e and f. G would only display H and I.

If either one of my questions have been asked, please kindly help me understand the correct text to use in the search box. Thanks

[June7]

1. The form can have a query as RecordSource. That query can have defined heirarchy of sort order.

2. This is dependent (cascading) comboboxes. Dependent comboboxes with Lookups don't work well in Continuous or Datasheet view forms. Review:
http://datapigtechnologies.com/flash...combobox2.html

[tigwebu]

Please explain more on the first item as I do not quite understand. I have my query that is places the id# in ascending order and the effective date in descending order to show the most current per id first. But how do I get the text box on the form, all of the different base by id number in descending order.

[June7]

Whatever sort order set in the query will carry over to the form when it opens.