Cascading Combo boxes- bound; Cant select

[AishlinnAnne]

Spreadsheet table design: Lets say that you leave the table as is with all of the Yes/No fields.
You get the forms, queries and reports completed. Then you realize that you forgot to have an option for "Ceilings". What happens?
You have to change the table,
which means you have to change the queries,
which means you have to change the forms,
which means you have to change the reports and quite possibly
you will have to change a lot of VBA code.

A total dB rewrite just to add an option.

Normalized Table design: You add "Ceilings" to a table. Done! Nothing else needs to be changed!

That makes total sense. However, Does that mean I will have to re-create my entire form to add the options? Right now the form is based off of tblJobs (with options).
And if I do go that route, breaking up the job details & options, would I then have to add a seperate PK for quote# like you mentioned before?

Thanks again!!!

[ssanfu]

Does that mean I will have to re-create my entire form to add the options?

I would (and do) use a main form/ sub form set up. The sub form is the options. Relational database 101......

would I then have to add a seperate PK for quote# like you mentioned before?

All of my tables have an autonumber PK field. The purpose of the autonumber PK field is strictly for linking table & records (with a Long Int field for the FK field). The PK field is never displayed on a form. See Post #12 and re-read the links again.......