Search results

Hi everyone, i am creating a database by importing data from excel than normalizing it. In the excel spreadsheet thre is a full name field and want to import it into access by splitting it up into first and last name. Some of the data in the spreadsheet have middle initials. ANy idea on how...

hi everyone. I am stuck in a dilemma. I have 2 tables: tblPerson PersonId LastName FirstName Title Gender tblClient PersonID Address City Email etc... 1 to 1 relationship On the main form i have a tab control with 2 tabs. On the first tab i have the tblPerson info which is part of the...

Hi there, i recieved this design from doc man in the table design forum and thought since this is a form question i should post here: tblPerson fldPersID, autonumber, PK fldFirstN, text fldMidN, text fldLastN, text fldAddrLine1, text fldAddrLine2, text etc. tblDoctors fldPersID, Long, FK info...

hi everyone, i sort of run into a dead end trying to figure how to structure this. I have three tables for the 3 roles, tblClients, tblDoctors, tblBusinessContacts, each with a Primary key and some unique information about each role. I'm not sure how i can track appointments to each of these...

Hi, i run into a problem deciding how i am going to go about this as i am just learning access. Here it is, it's for a nutritional company. I have 3 different types of clients (Average customer, Doctor, Business Contact). Between these 3 clients they have some similar fields and some...