modify table fields based on selections from forms

[Matt]

I am building a database to organise lines of conversation. The
conversations are only displayed based on conditional data. For example:
"What a hot day." only displays when weather is hot. I have a table for
type of conditional types, and a table for each conditional. For example the
conditional table contains: summer, winter, spring, fall, morning... and
there are tables for season and time of day.

I want to build a form that allows entry of the conversation, but adds
fields to the table based on the type of conditional. For example: The form
contains a field for conversation and a control to add a conditional
(probably a button). when the button is clicked, A new field should appear
to enter the conditional (A drop box from the specific conditional table). it
should be possible to add as many conditionals as you want. Any help
appreciated. Thank you

 

[Adrian Jansen]

I am building a database to organise lines of conversation. The
conversations are only displayed based on conditional data. For example:
"What a hot day." only displays when weather is hot. I have a table for
type of conditional types, and a table for each conditional. For example the
conditional table contains: summer, winter, spring, fall, morning... and
there are tables for season and time of day.

I want to build a form that allows entry of the conversation, but adds
fields to the table based on the type of conditional. For example: The form
contains a field for conversation and a control to add a conditional
(probably a button). when the button is clicked, A new field should appear
to enter the conditional (A drop box from the specific conditional table). it
should be possible to add as many conditionals as you want. Any help
appreciated. Thank you

No, you *never* want to add fields, you have to organise your design so
you just add a record for each type of conditional. Study the design of
Duane Hookom's "At your Survey" database to see how to do this.


http://www.rogersaccesslibrary.com/duanehookom/duanehookom.htm


--
Regards,

Adrian Jansen adrianjansen at internode dot on dot net
Design Engineer J & K Micro Systems
Microcomputer solutions for industrial control
Note reply address is invalid, convert address above to machine form.