Re: Can it be done?
- From: "BruceM" <bamoob@xxxxxxxxxxxxxxxx>
- Date: Fri, 19 Sep 2008 07:29:02 -0400
The place to start with such a question is the database design. Presumably you have a Client table and a related AdvertisingInfo table. Is there also an Options table, or is that part of AdvertisingInfo? Does AdvertisingInfo or an Option apply to just one client, or could it apply to several clients? Why do you want to show the Client AdvertisingInfo and Options on a seperate form from the Client information?
Or do you mean you would have a table with hundreds of AdvertisingInfo or Options records, and that you select one or more for each client?
The short answer is that you would probably use a combo box or list box to select the options. A subform is a way to display records that are related to the main form record, but does not by itself provide selection options.
More information is needed for there to be a meaningful response. It would help if you describe in real-world terms, perhaps with some sample data, just what you hope to accomplish.
"Melissa" <melissafleetwood@xxxxxxxxx> wrote in message news:%23Aq3IEjGJHA.4600@xxxxxxxxxxxxxxxxxxxxxxx
Hi there
I would just like to know if it can, and what is the best way to do a database which is capable of the following:
i need to list all the clients on a form, and then all of their advertising information and options on another form (there are hundreds of these positions and options). what would be the best way to be able to select the advertising options and methods? a subform? a list box?
.
- Follow-Ups:
- Re: Can it be done?
- From: Acc
- Re: Can it be done?
- References:
- Can it be done?
- From: Melissa
- Can it be done?
- Prev by Date: Re: Can it be done?
- Next by Date: Form active control change event
- Previous by thread: Re: Can it be done?
- Next by thread: Re: Can it be done?
- Index(es):
Relevant Pages
|
