MS Access : two questions

1. How to I make a pull-down list which dynamically reads its option fields from a table?

For example, I might have a form with a pull down list of options for "How did you hear about us?" (word of mouth / newspaper / TV advert / etc). The "options" should not be set in concrete. Rather, they should be listed as a table somewhere. This way, if I add "radio advertisement" to the table... hey presto! t appears as an option on the pull down list.

2. How do I get autonumbers (e.g. client_ID) to reset after deleting all fields, so I can start afresh?

For example, I might spent a lot of time getting the forms sorted on a database. During the process, I would have made several "fake" records / forms in order to test my data. Now that I'm satisfied, I want to delete all fields and have the client_ID auto-number restart at 0 (zero). Instead, it starts at a larger number, in respect of the previous data entry (still thinks it's up to record 207).

P.S: I'm using Access from Office 2000 on Win-98 SE

 

I think I can help you out.

1.) You have partially answered your own question.
Create a table containing 2 fields: autonumber and your how did you hear about us choices.
Then create your table that contains fields for all the other data you collect. Create a field for the choice in design view and choose lookup wizard.
Follow the steps and you will easily be able to do what you want.

2.) You can't. Well actually you can, but you have to delete the autonumber field and then recreate it. There are a couple of other ways to do it , but I thinks thats the easiest.

 

Thanks