Search results

is this like a combo box? would I put that in my form or in my table? I tried to use a combo box in the form but Access still refused to let me leave the customerID field blank(which is the foreign key field in job log) My idea of converting the customer information into a subform has...

I think I've solved this issue...... :) I created a new form....from the same Job Log table but I added the Customer Table as a subform instead of just adding the customer table fields to the form. This appears to let me add a new Job without having to assign a customer to the job. As far...

I may try that third table option, but I'd rather not create excessive complication.....lol This issue ONLY occurs when entering data in the form....when I enter data directly into the Job Log Table, I do not need to have a customer assigned. I get NO error message when I leave the...

I apologize for all the verbiage. I find it difficult to be clear and yet be brief. :D I also can't seem to find a way to attach an image of my table or form....i'll keep working on it. Hopefully, I'll figure it out soon. I really appreciate the help and advice!! I'm obviously very new...

Should I lose the referential ingegrity in my relationship? I'm not sure that would be what I want.... The flow of work always starts with a job number which is developed on the Job Log Table. Often a customer requests a quote which immediately becomes a "job" and gets assigned a job number and...

I'm hoping someone can help me figure out how or why I can't put a null value in a foreign key field?? Here's my situation: I have 4 table, each with a one to many relationship to one other 1-Customers-contains the billing information for jobs 2-Job Log-contains job opportunities, job number...

I hope to gather quality and yet simple answers to my Access questions on this forum. This is the first "tech" forum I've ever been involved with so be gentle...lol I live in USA and have just started using a database. I've reviewed several "help" topics from multiple sources and I think I'm...