Search results

Thx Well thx it was helpfull and new info for me

Hello ALL, I want to know how to reset (to start again from 1) my primary key field. As an example i have the "Customers" table with the field "customerID" as PK now i entered many values (20) then i deleted them but i want to start again and the "customerID" value starts with 21 i understand...

OK here i'm Again After taking a look to the whole database I want to say: 1- I think i have no problem concerning the tables "customers", "products" and "employees" just i'll ask about some question to make clear for myself: a-the 2 tables "employees" and "products" are almost fix for me. i...

THX Anthonys Your answers were so helpful and organized and that's why i added your reputation!!:) OK now i understand better the first part of my project which is the table, i'll make the changes on the suggested things that you said (address, currencies..) and delete the fields from the order...

ok but OK i'll divide the address into many fields. BUt about the fields "gender" and "nationality" how i can make them drop down menues? I thought about that but i don't know how to make it inside a table! i mean i have a basic idea about making that in a "form" not a table can u please tell...

I hope I'm posting in the right place, if no let me know where to put this post. I'm trying to make a database for my customers to enter information related to them and what they bought from me to be able after that to make some statistics and analyze.. So the first Table I made is: PART I...

Thanks Thanks for your replies and help, sure i'll not use the 255!! i'll not even use more than 30!:) By the way, i have some general question about a small project i'm doing, do you have any ideas where to post it? i'm confused in which section! since the database i'm doing will contain...

I would like to know if there is a maximum nb of columns to use in a table or at least a prefered max nb. For example i have a table "customers" and inside i have "name" "last name" "age" "gender"..and so on is there a limit? By the way i'm using access 2007 Thx for the explanation in advance.