Amend data

[Hayley Baxter]

I currently have forms where I can add a supplier to my suppliers table and add a contract to my contracts table. What I didn't think about was what if the telephone no for a current supplier changes which in the real world is very likely. Would this be better achieved if I created a new form called Amend Suppliers details and perhaps added a save cmdbutton? or can I add something to my current add form which will also allow me to ammend current supp details.

Thanks in advance
Hayley

 

[Rich_Lovina]

It is not clear why you cannot edit a phone number already in your tables. If you have made the Phno a primary key, why not add an autono. field called SupplierID?

 

[Hayley Baxter]

Perhaps I am not making myself very clear. The only suppliers details I have in my contracts table is the supplier id and this is an autonumber. What I was referring to was once the db is opened without the db window showing I am still going to have to make changes to any suppliers details because this is not affecting the design of my db I thought I could create a form to save me going into the actual table to do this.

Hope Im making sense

 

[Rich]

You should only enter data into tables through forms or code, not directly. You need some form of switchboard / navigation main form which will open the neccessary forms for data entry. The form wizards do a pretty good job of creating them for you.
HTH

 

[Hayley Baxter]

Thanks Rich I already have a main switchboard I suppose I should just add another for called Amend Current Suppliers and open this in edit mode.