G
Gary
Search Fields to filter results
I have a fairly simple form/db created to store information for programming
a fireworks show. The DB is created, and the form to enter the data is
created.
Now I want to develop a “Show Builder†form to do what the database was
created to do. (plan and program shows based on the stock of shells that
have been purchased)
For each record, there are three color fields (Color1, Color2, Color3)
Because for each shell there are usually up to three colors, 2 effects, and 2
different sounds. I need to have a form with a combo box titled color when
dropped to “blue†lists the records in a sub-form below of all records with
blue as Color1, Color2, or Color 3) Same thing with effects, and sounds. I
have tables created for all colors, effects, and sounds and the data-entry
aspect is a combo box on the main form, so the answers are all standardized.
I want to be able to assign a cue number from the sub-form, and set the
record as used, so it wont show up for any other searches.
Is this possible without some heavy duty coding?
I have a fairly simple form/db created to store information for programming
a fireworks show. The DB is created, and the form to enter the data is
created.
Now I want to develop a “Show Builder†form to do what the database was
created to do. (plan and program shows based on the stock of shells that
have been purchased)
For each record, there are three color fields (Color1, Color2, Color3)
Because for each shell there are usually up to three colors, 2 effects, and 2
different sounds. I need to have a form with a combo box titled color when
dropped to “blue†lists the records in a sub-form below of all records with
blue as Color1, Color2, or Color 3) Same thing with effects, and sounds. I
have tables created for all colors, effects, and sounds and the data-entry
aspect is a combo box on the main form, so the answers are all standardized.
I want to be able to assign a cue number from the sub-form, and set the
record as used, so it wont show up for any other searches.
Is this possible without some heavy duty coding?