Creating an FAQ database

[rescobar]

Hi I'm looking for some guidance that will point me in the right direction. I want to make an support FAQ database. The user would open a form, select items from lists, enter a summary and a description. The specific issue I having is how to populate a list based on a previous list selection. Here's an Example:



From the FAQ Form:

List 1: Categories, Planes, Trains, Automobiles

Select Automobiles

List 2: This is now populated with Ford, Chevy, Honda

Select Ford

List 3: This would now be populated with Ford product models.

Any help will be appreciated, thanks.

[pbaldy]

Does this help?

Baldy-Cascading Combos

[rescobar]

This was a big help. I have been able to reverse eng the example. I tried changing State to Product and City to Model. I blow it up when I edit the Visual Basic Script to reflect City and Model.

[pbaldy]

Glad it helped. If you get stuck, post your effort here and we'll sort it out.

[rescobar]

I'm using the Static City state. I have been editing the example to change State to Product and State to Model. I believe that my editing to the Visual Basic Script is what broke it. When I attempt to make a selection to a list it populates an error msg related to the recordsource.
The record source '~sq_cCascadingComboSample~sq_ccboProduct1' specified on this form or report does not exist.

Thanks for your help, I'm a hack doing my best.

[rescobar]

Ignore last msg. I have it working now. I'll keep banging on this and see where it leads. Thanks

[pbaldy]

Happy to help.

[rescobar]

I have made a form. It has Lists for Product and Model. There's also a text boxes for Summary Field and a Detail Field, these are set to Rich Text. When I open the form it is not open opening to full size. Very truncated. What should be changed?

[rescobar]

By accident I found Size to fit form and that fixed it. Pure luck.

[rescobar]

So now I have a form with everything it would require to be a simple FAQ database. The next part is how to convert this single form into a data base that can be used for tracking FAQS.

[pbaldy]

I'm not clear on the question. Populate your tables with the appropriate data and turn it loose in your users.

[rescobar]

I have one Table called Models, it's just the contents for List 1 Product and List 2 Model
There is one form which now has the two lists, a summary field, detail and solution field.

I'm now trying to figure out to make a data base out of this. Do I need t create another table?

[pbaldy]

Well, you have the cart ahead of the horse then. Laying out properly normalized tables should be your first step. As to whether you need another table, I don't know enough about the purpose of the database to venture a guess (but almost certainly yes). Since that's really a different topic, I'd start a new thread in the tables (or database design) forum. Make sure you give an overview of the information the db is designed to store.

[rescobar]

Thanks for all your help. I got the dadbase working. I was able to get the horse in front of the cart by editing Property Sheet. I copied the settings from a form I made with the wizard. Also I needed to add a record source so it could write to a table. So back to your orginal example. If I select City before State then list cannot populate properly. Is there a way that selecting State would always populate with the poper cities?

[rescobar]

I discovered that a MS security warning was prevent the script from running proprely.