Search results for query: *

Thanks for your help. Smitch

Hi, I need to create a database that will be used reguarly pretty much to keep an address book of my clients, with a few extra fields specific to my business. I want to be able to have a user go to my website and fill out a form. I want the data from that form to automatically be added to my...

In my DB there are 4 types of customers as defined in the Customers table. Individual Business Government and Charity. In the Orders table I record the Price charged for a particular order. It is linked to the Customers table through the CutomerID field. How do I calculate how much of the...

Hi, I have yet another question, Ive set the tables an relationships up and Im now working on the Forms. I have: tblOrders OrderID CustomerID Date etc... tblOrderdComponents OrderID ComponentID QTY tblComponents CompID CompDescription CompPrice My questions are: 1) I have started creating a...

My Database has tables like this: tblOrders OrderID CustomerID Date ....etc tblOrdComponents[/u OrderID ComponentID Qty [u]Components ComponentID CompDescription Price I want to setup a 1 to many relationship between tblOrders and tblOrdComponents as one order can include many components...

ok thankyou for your help. Much appreciated. Thanks

ok, the mock up database you posted is very similar to how I have setup mine. At the moment my database has two table similar to the first two tables in your example. From what you said though, it still seems impossible to store mutliple skills for each employee? Thanks again Smitch

ok, that works well when designing a form but is it possible in a table. In my table I have a field with about 10 different items. I need to be able to select any combination of those items. If I can't do this with a multiple selection list box how should I go about it? I understand that it can...

Hi, I want to have a multiple selection list box as a field in one of my tables. Even better would be a list box, which drops down to display multiple checkboxes that the user can select from. How would I go about this? Any help would greatly be appreciated. Thanks in advance. Smitch

Hi, Im attempting to connect to a database on my remote testing server. I've set everything up and double and triple checked all the setting but I keep getting this error. MySQL error#: 1045 Access Denied for user: 'username@zeus.liveshare.com'(Using password: YES) now the problem is I have...