updating tables

[kabir_hussein]

Hi

i am doing a database where user select items from a list, however when they are selecting an item (partID) from the tenderlink (table). some users may need to add new part ID. So i have created a button which opens up another form thus allowing users to add a new item. Once saved the user clicks on exit and is returned back to the first.

User select the partID from a drop down box, however when i add new items then go back to the form, it is not on the drop down box. but if i exit the form then return it on the drop down box.

I have checked my relationship diagram and i have clicked on the cascade update/delete etc

what could i be doing wrong

here is a screen shot of my table-i am also having the same problem with the supplier table

many thanks

 

[kabir_hussein]

hi

many thanks for your help, it works now however i have another problem very similar to the previous one.

Except this updating requires me to update a table while i have a form open which relates back to the table. i have two forms one which is used for editting orders however this form can only be editted so i made another form whihc is used for add new orders which once saved i hope to include in the current form-If you know what i mean.

The order form is linked to a query which required the user to type in the Order number when it is open

I have attached a screen shot

many thanks for the help