Recent content by lukyhare

Hey joeselch, Thanks for the post and sample. I will take a look and see if i can get your sample to work with my form. Will let you know later about how it goes. Best regards, Len

joeselch, Which do you think is easier? If I wanted to go with putting a new field in the company table, how do i set up the querry so that in the combo box it only allows you to choose the contacts relevant to that company. Do you think the check box idea could work too? If i wanted to add...

I had another idea, would it be better to instead of having a combo box [Main contact ID] in the main form, i could have a check box called [Main Contact] in the sub form where each contact person for that company gets filed. Is this an easier and better way to point out which contact is the...

Oh my bad, thats what i meant, i made a querry of 2 tables to use in the form. The querry is using 2 tables: 1CustomerCompanyInfo 1CustomerContactList The fields: 1CustomerCompanyInfo: CompanyID (Key), CompanyName, CustomerID, Address, City/State, Country, PostalCode, WorkPhone1, WorkPhone2...

First thanks for all the feedback and suggestions. joeselch,mohammadagul, Im trying to get the querry that u suggested to work in my form. I made a querry of my customer contacts and main contact person forms using just Company ID and Customer ID. (i tried company name also but figured...

Im making a form with a sub form as follows: Main form: Customer Company Info (main Company information) sub form: Customer Contacts (information on each contact, each company can have multiple contacts) I have a combo box that is the main contact person for the company (each company can...

KenHigg You could use a dlookup() to see if it existed in a before update event. ??? ken Does anyone know how i can do that? Thanks, Len

Does anyone know if its possible to make a yes/no check box that is limited to one? I have a client table and a client contacts table that's related to the client table. One client can have many contacts. Im trying to see if i can put a check box field in the client contact table called main...

Have been swamped with work and havent had time to fix up my database. Just wanted to thank you guys for your replies, i really appreciate your time. Im gonna sit down and look at the info you guys have given and see if i can put together a working database for my POs. mjmmartin, I know your...

First off, Man you guys are quick. Mile, thanks for making the splits, i should have mentioned earlier that i only copied part of my database that focused on one of the problems i was having. I realize though from your splits, that i named my fields wrong. I should have named them FabricID...

Hello all, need some help on some table designs, any opinions would be appreciated. I have 3 tables now that are related and probably need to split these into smaller separate tables. Ive attached a file with the tables im trying to fix to better show what im working with and another excel...