Search results

I created a New Machine System under the newly added Machine and the code is working as per desired. Now the FLAW is when I create a New Machine Sub System for the newly created Machine System i want to see only the new Machine Sub System not the other items. You will get a clear picture by...

I am thinking of using the Dmax or DLast function and run the Select query but not sure how to do it.

Now the next part is trickier. What if I wanted to add new Machine System, say " Machine System C" under the newly added "Machine B". I have attached your updated database with an extra text box " Add new machine system". This text box is as per my one-to-many relationship (image attached) where...

Wow! This is exactly what i needed. Thank you very much!

I have attached the database. The requirement is from "Create New Machine" Form if you create a New Machine (top right), say "Machine B" and click on "Add Machine" button, this new record must populate the tblMachine (which is happening right now) but this same "Machine B" ID must also populate...

I did as you told but slightly changed the code. I am trying to use the Dmax to retrieve the last added record. Is this approach right? I seem to be a bit lost here. What ever text i am adding in the text box to add new machine i am getting an error saying "the changes would create duplicate...

Could you please provide the link to this thread?

When you mentioned "SELECT (T1.MachineID)+1 AS Expr1", what is 1 AS Expr1? I beg your pardon if this is a silly question.:(

In the form i have created a text box with a button to populate the new machine into tblMachine and Junction Table. The new machine created is populating the tblMachine but not Junction table

You see from the attachment. There is this tree (blue) that was already existing in the excel. I have put this in the database. Initially you will feel that it is one-to-many relationship but the requirement is, to a newly created machine (black circle) you add some or add all the machine...

Thats because in the beginning I am assigning one machine to two machine systems (1,1) and (1,2). And then I am creating a new machine, giving it an autonumbered ID 2 in the tblMachine and then assigning the previously available MachineSystem ID's, hence (2,1) and (2,2), in the Junction table.

I am sorry I made a mistake, here its actually 1 1 1 2 2 1 2 2

I have many to many relationship between tblMachine, tblMachineSystem,tblMachineSubSystem and tblComponents. There three junction table between them. I have a form with four listboxes for each table. When i click a button under the first listbox (listMachine) it gives me the items in the second...

I am a student doing my masters and right now i am carrying out a project in MS Access