Button to Add New Record in a Table

[Ari]

Hello friends!

I have a table SUPPLIERS that consist of ID, IDCITY, SUPPLIER and another
table called CITIES which it consists of ID, NAME....

..... and I want to make a BUTTON in my main Form, to add new records in the
suppliers table.

before adding a registry, a city would be due to choose and just soon to be
able to add a new SUPPLIER in the city that corresponds in the table
SUPPLIERS to him.

I hope understand me and consider that I am newbie

Thanks.

 

[Guest]

There's not really a question here, Ari. However, you can easily add the
button you want. As for requiring the city to exist, before adding the
Supplier, put another button, next to the field they are using to select
City. So that if the City doesn't exist they can click, and go to another
form, to add the City to the db.

Sharkbyte