Search results

Yeah, I had a similar problem earlier. I think it was due to the fact that you do not have one of the tables related to the other table. However I am not absolutely sure about it.

Well that was what I wanted to do at first, but I could not get it to work. I could have it that way... or alternatively just have a link within the mother form of frmCustomers to go to frmSky ( Where one would create a Sky Sale, after having created the customer) or frmPhones (Where one would...

I have the following tables: tblSales, tblCustomers, tblEmployees, tblInstall, tblCreditCheck. There are 6 products in 2 categories: Sky: Sky A, Sky B, Sky C and Phones: 3G - A, 3G - B (these are related by tblProducts to tblSales) tblSales has lngCustomerID and lngEmployeeID. I want to be...

Accept my apologies for the confusion, however I did try to delete one of them as soon as possible so that not to create confusion. I guess I was not fast enough... sorry.

I have a database of employees, sales, products(Sky and Mobile Phone Contracts) and customers(Need to be common and shared between all products). ( A door-to-door marketing company) Since each product requires different inputting tables, I have inserted all the required fields into the tblSales...

Tried doing some changes... and it all does not work... :( I took a wrong path somewhere. Here's the attachment (Without the quary, but with forms)

Reattachment.

Right trying to attach my DB. It does not have the quary that I want in it though :(. Gonna reattach now...

I feel rather stupid now... but it is not working as intended. The things that I have done are as follows: http://www.dmitri.distyle.co.uk/img/db_Tables.JPG (Tables that I have created) http://www.dmitri.distyle.co.uk/img/db_Rel_Quary.JPG (Relationships + one Quary which does not input data...

Thank you. I will give it a go, and I will post the result here. ;)

Dear Malcy ;) Thank you for your reply. One question that I already have is: My understanding is that I need a separate table for each product (Since each product has different attributes that need to be a part of the database i.e. "Install Date" and "Install Status" for Sky, "Credit Check...

Hello, I must say that I am not very experienced with Access.. hence why I most likely have ran into this problem. However I did try to read manuals and tutorials to get me through it. (Failed :) ) Hopefully somebody from these forums can help. The database that I am trying to create is for a...