S
SuseMarc
Guest
Hi im creating a database for a company i work for, and im finding it challenging as its the first one ive designed! Ive completed pretty much most of it but im having a problems with one form. The point of the form is to enter new jobs that my company have taken on. I have a form and a subform in there, the main form has the client and shipment details addresses etc.. and the subform is meant to be there to enter the product informations.
My problem with these forms atm is that when i select a client (by company name) i cant select the drop down box in the subform to choose a product.. and its the same vice versa. The other problem is that when i select 1 product (obviously without selecting a company) the form increases so i can enter a 2nd product (as it should) but again i cant select a second product.. In none of these situations do i get an error message..
Ive tried everything within my limited knowledge and nothing has worked, i cant seem to get any luck with google either :/ .. now im guessing it's ewither a problem with my relationships or with the query im tieing the tables to the forms with.
Ive attached a screenshot of my relationships, if you need any more information please post it here and ill get it..
My problem with these forms atm is that when i select a client (by company name) i cant select the drop down box in the subform to choose a product.. and its the same vice versa. The other problem is that when i select 1 product (obviously without selecting a company) the form increases so i can enter a 2nd product (as it should) but again i cant select a second product.. In none of these situations do i get an error message..
Ive tried everything within my limited knowledge and nothing has worked, i cant seem to get any luck with google either :/ .. now im guessing it's ewither a problem with my relationships or with the query im tieing the tables to the forms with.
Ive attached a screenshot of my relationships, if you need any more information please post it here and ill get it..