Search results

but how do I recover then? :-s

access complains about the order form...the order number..saying like: "date in the table productspurchesed violates integrity rules"...... ??

um..ok, thanks :) so, how would I do this? I am a newbie btw..and need help with this as it's part of the "coursework" for uni..and they really didn't explain anything apart from. here is the work..get on with it

ok...thanks :) so if I do this in the relationships, will it work? and also, will it have any effect on the current way of working on the database? in terms of operations, will it do the same thing as now after I do this enforce integrity thing

ftp://temp:temp@techftpserver.co.uk/mdffc.zip

um....as soon as I put in the order form table, it's when it goes wonky: ftp://temp:temp@techftpserver.co.uk/mdffc.zip it's in a query called employee status

hi there. making a query where I can get details: Customer number, name, address Employee number, name product details (product number, description, price, total, order amount) but it shows nothing. if I only put in the customer number, employee number/details and customer name, and order...

yes :) but i was wondering if there is a way to do it in the main order form? otherwise, if not, then this is ok too :) cause if for example, the employee changes (from 1 to 2) in the order form, i want it to update that customer details TABLE so it shows the update....

hey! :) i never got a sample...all i got was that Edited database that u done ... where u put in the employee details in the customer details...

the person said that, which ever employee places an order is responsible for that customer. so, should I put in the employeeId in the customerdetails table? IF so, then how do I do the same thing like i have done, just now, with the order form table (taking the employeeID field and making it a...

ty! :)

nearly got it! I dragged the employeeID from the order form field list to the form detail, changed into a combo and selected the row source from the employeetable........ But it doesn't like showing the Lastname! only the first name :( still working on it...

ok well I added the combo and text box manually in the order form and looked up values in the tblemployees. great but again, it doesn't store the values in the database, any value u select overwrites the previous record values of the employee ID :( and it don't store it in the database! :(

getting a bit confused here: created the employeetable and made a form using the form wizard. added EmployeeID in the customerdetails table. then, I went in design view of the order form. Now, should I ADD the employee subform? or should I create a combo box manually? or should I add the...

thanks for that, i am trying it out now :) I don't follow this part: tblOrders: OrderID OrderDate OrderDescription OrderStatus EmployeeID tblOrderDetails: OrderID ItemNumber ProductID Quantity UnitPrice the first table, do I have to create it? or is this like a "cut down"...

just now, made a relationship like this: added the employee number in the customer details table (as I want the employee to manage a particular customer number(s)) then add the empdet table in the relationship and linked the employee number from the empdet to the employee number to the...

right so, I made a new table called empdet. contains employee name and number. then went into the main order form. added a combo box to look up values in that table (employee number) and then added a text box to do: =[combo246].column(1) to show the employee name that has been selected as a...

yes but HOW to set them up correctly? this is where I need help.

can't do it :( I tried! i put in employee number in the order form table. made another table in design view containing employee number and employee name. the in the main order form, i put in the employee name and number in the SQL Statement of the main order form I think dragged the...

tyvm :) so, basically create an employee name and number in the order form table and maybe do the combo thing (like the customer details type combo) and then.....? or is there a way to do it in a subform way too? which way do u think is best and how can it be achieved?