Search results

So what would be the correct value for, say i have this Form: Combo Box with serial number: Subform with a Query: Serial number Old Slot New Slot 2151651 10 11 2151651 11 12 What is the name of the feild with the 12 in it, the last in the...

I'm a bit confused, what is supposed to be inbetween the ' " & '?

Tried that, no luck. Is there a way I can just make the "New Slot" field update the corresponding field in the other table without showing it in this query. So when they type in the new slot on the form it automatically updates to the current form?

How do I join them correctly?

Essentially what I want to do is take the value in "New Slot" that the user enters in on the most recent repair history log and update that to the current slot on the other table. With this SQL I was trying to do two seperate colunms and have the user update the current slot manually but it...

SELECT History.[Serial Number], History.Recieved, History.[Sent Out], History.NCR, History.[Old Slot], History.[New Slot], [VME Chassis Contents].[Slot Number] FROM History, [VME Chassis Contents] WHERE (((History.[Serial Number])=forms!frmRepairHistory.cmboRepairHistory) And (([VME Chassis...

I just read that you Could edit the data if you created a one-to-many realationship with it, but would I have to enforce the integrety? It wont let me do that because I have null values in some of my boxes on the first table, because not all parts have a serial number.

I tried a few of those things that i thought might be it and none of them worked. Now when I make the query only pull data from my second table I can edit it but not when I add the related data from the first table in it. Any idea? All your help is appreicated.

So heres whats happening. I have two tables, both of them have a serial number for a certian part. In one table I have all of the data for that part and in the other table I have the Repair history for that part. Well in getting the parts repaired sometimes they go back into different slots...