Search results

I have a form that has some unbound text boxes in it, when I switch to a new record I want the unbound text boxes to clear.

I am trying to take the content of two fields from one table and dump them into the other table, I created an Append Query pulling up just the main table and appending to the destination table but it doesn't copy the info when I run it. I also pulled in both the tables (and yes they are joined)...

I also have another dilemma, this is supposed to launch on 7/8/13 with a minimum of the repair tech entering his info into the repair section of the database and the patient info form being used later if it isn't ready. I initially was going to link them by RepairId and have the person taking...

Maybe I should join them by RepairId, the person taking the call will fill out the customer complaint form and the RepairId will be an auto Number...then when the repair tech works on it they search by the RepairId? Does that make more sense? I guess the patientId number was my way of the...

One patient could have many complaints but there would be different dates to separate or sort them. I was going to have a drop down combo box with part numbers and descriptions, but if multiple parts are used I should probably keep that in a separate table then? There will only be 1 tech (for...

So make another table with dates and serial numbers that links to the other two tables and then I query that third table to see what serial number is in or out? Or do I make a form for that table also? :confused:

AccessBlaster, These are the two tables I have so far, I am not sure how to go about tracking the Loaner devices so I know when they are in or out. Initially I had the loaner table separate. Thanks Patient Info - PatientId Search Date of Call PatientLastName PatientFirstName Address City...

I am creating a database for our small service department, I have about 25 loaner devices that will go out while a device is getting repaired, is there an easy way to track these? The loaner will be tied to a repair number while in use, then it will come back in to be available for use again...

I am basically a rookie and have given the project of creating a database at work so I will probably be hanging out here a lot to look for guidance.