Combos and Subforms galore

[Milothicus]

I'm still working on the same database, and i still can't get my subforms to work.

I have a table that includes client company details: name, address, phone, and fax. it has a client_id field primary key.

i have a table that includes contact details: name, phone, email, contact_id primary key.

my main input table has client_id and contact_id fields as well as many others that are relevant to each enquiry.

I'd like to have client and contact details on my main form (however i can do it, most likely as a subform) but i don't need the client_id or contact_id, as they're just internal indexes.

I'd like to enter new records for the client and contact tables each time i enter a new enquiry, but have the info autoexpand with the names and fill in all the other info.

i would think that the input table could store which client and contact are associated with each record, but i can't get it to work.

i also can't get the subforms to recognize the fact that there are records in the client and contact tables......and i can't get it to allow me to input clients and contacts....

it seems like such a common requirement, but i can't get any of it to work.

i'm not even sure what my question is, other than; what's the logic you follow to set up the form? wizards? design control by control?

if i do use subforms for the client, how many columns do i need in my combobox? how do i get a combobox choice to populate other fields?

any help is appreciated.

 

[neilgraham]

I'm still working on the same database, and i still can't get my subforms to work.

I have a table that includes client company details: name, address, phone, and fax. it has a client_id field primary key.

i have a table that includes contact details: name, phone, email, contact_id primary key.

my main input table has client_id and contact_id fields as well as many others that are relevant to each enquiry.

I'd like to have client and contact details on my main form (however i can do it, most likely as a subform) but i don't need the client_id or contact_id, as they're just internal indexes.

I'd like to enter new records for the client and contact tables each time i enter a new enquiry, but have the info autoexpand with the names and fill in all the other info.

i would think that the input table could store which client and contact are associated with each record, but i can't get it to work.

i also can't get the subforms to recognize the fact that there are records in the client and contact tables......and i can't get it to allow me to input clients and contacts....

it seems like such a common requirement, but i can't get any of it to work.

i'm not even sure what my question is, other than; what's the logic you follow to set up the form? wizards? design control by control?

if i do use subforms for the client, how many columns do i need in my combobox? how do i get a combobox choice to populate other fields?

any help is appreciated.

First off you need to normalise your database and proceed from there.

A typical client/contact database will include the client id in the contact table and does not need the contact id in the client table.

Start with a simple client/contact form and ensure it works.

The contact form can be a subform on a tab control with the master child linked on client id.

If you open an enquiry and want to show all the customer details just have a combo box on the enquiry form which queries the client table. The selection you then make can then be used to show the underlyng client details in several ways.

Get the basic forms to work first though after you have normalised the database.

Neil

 

[Milothicus]

I ended up doing it a slightly different way. i was hoping to have both client and contact subforms on a main input form. some clients have different contacts for different projects, so i need to keep them separate (i think).

i had forms working for both clients and contacts that updated all the fields within them when i chose from the combo box, but when i placed them in my main form, i could choose from the combo box, but the other fields wouldn't update, and i had all kinds of different errors when i typed in something new.

what was most frustrating was that i had one clients subform working perfectly, but i couldn't get it to work with contacts, and i couldn't get it to work with clients a second time. i couldn't find any difference in the options, and the codes associated with the clients, but it just wouldn't work.

thanks for the help, but i've got it working differently now......

I would post examples, but i can't get it small enough to post.......