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

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?

It sounds like you have stored supplier related data in the contract table. The ONLY piece of supplier data that belongs in the contract table is the SupplierId. Absolutely no other piece of supplier data should be stored there for exactly the reason you have discovered. Whenever you want to show supplier data for the supplier assigned to a contract you use a query that joins the two tables.

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

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

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.